To achieve your requirement, you need two parameters with value of category.
below is the calculation and parameter, and sample output for your reference. workbook attached as well.
Hope this helps
Sample (12)_v10.2.twbx 18.4 KB
Hi Zhouyi Zhang,
Yes, this helps a lot! Thank you very much.
I have two more other questions related to this problem that I like to know if Tableau is capable of doing.
First, can the filter be added dynamically? For example, now I have two parameters but at some point, I want to filter with three parameters. In that case, do I need to create three filters for doing that, or can I have Tableau creating a new filter field every time I use the last available filter. I’m thinking about something like choosing the first category to filter, the view changes and a new filter field appears with the new values that can be filtered, and so on.
Secondly, is it possible the filter action be applied when I select one of the bubbles, instead of using filters traditionally?
Thanks in advance,
To your questions, if these are somethings that from user requirements, I will suggest to reshape your data from query/etl rather than using tableau as this solution is purely trying to interpret your query to tableau, and I understand it is not a nice way, but this is the only way.In terms of better interactive user experience, I recommand restructuring your data in a better way (it may bring some redudency and dulplication, but easier)