I am facing an issue today with a dashboard I have uploaded to the server.
Eg: I have a heat map of Category (Cat A, Cat B, Cat C, Cat D) with sales unit quantity
I have the sheet to show the Sum(Sales in $)
I also Have a filter at top where I have Cat A, Cat B, Cat C, Cat D in the drop down.(multiple value selection option)
Now in Tableau Online I am selecting the Cat A from the Heat Map and the Sum(Sales in $) is getting filtered by the action filter. Now I am clicking on the Cat A again to deselect. and I see the Sum(Sales in $) for all.
Now I am selecting Cat B and Cat C from the filters (worksheet filter)and now the Sum(Sales in $) chart is blank. So it seems its holding the action filter value even though I used 'Show all values' and not the 'Leave the filter' or 'Exclude' option
If I Select Cat A and Cat B now its showing the result for Cat A Sum(Sales in $) only and not the result for the both. Tableau desktop version is working as expected though.
can someone please guide us where am I going wrong?