1 of 1 people found this helpful
In your case it is showing the sum total of the sales so that is why it seems similar but through color legend it is not filtering out the data but when you apply through filter it is actually filters the data.
Kindly use the Percent of Total to understand the case clearly. I have tried with Percent of Total, kindly refer to the below screenshot:
Now if you refer to the screenshot then you will notice that Category filter is filtered out the Technology data out of 100% and color legend did nothing except highlighting Furniture.
I hope it helps.
Both work differently,
Filter: If you right click an option within a sheet in the dashboard and select exclude or keep only, that action applies to that sheet only.
Legend: It is basically used for highlight. You can select a color on a legend though, the highlight occurs on all sheets within the dashboard which use the same dimension.
Attached is the tableau file for your reference.
Book1.twb 202.1 KB
Thank you all. Nice of you for taking your time to explain this to me with examples.