I have a dashboard that has two filters, Category and Sub-Category, for the example I am using the superstore data. I would like to have the Sub-Category filter only show relevant values and at the top of the dashboard I would like to display summary statistics. Below, I would like to have bar and whisker charts of all the Sub-Categories in that Category. In my example, each Sub-Category has a unique color but what I would like to do is color the filtered Sub-Category as red and the rest grey.
Is there anyway to do this while keeping the Sub-Category filter as a filter that shows relevant values only and in my real data the Sub-Categories can change month to month so I would like that to be dynamic. I had thought of a way to do this with a parameter using the values of Sub-Category but it wouldn't show relevant values and it would have to be updated manually.
Any suggestions? Example workbook attached.
Here are the options I see:
Filter - will show a relative list but won't work for your needs. A filter does only one job, filter the data. It can't be accessed in a calc or for colors.
Parameter - will do the job, but will be a static list, no relative filtering
Set Actions - will do the job, can be filtered relatively, but requires you use a viz to show the list so can be long.
You could use set/actions with a viz in a floating container. Right click the container in my example sheet, select floating, then right click the container and select show/hide buttons to toggle it. You can mess with those within your layout to may it less of a eyesore.
Here's a screenshot with it closed.
