Filter Pane interactions

[keithW]

Hi, 

I'm looking for a way to edit the interactions that a filter pane has on a sheet.  Ie: If I select a value on a filter pane it will only affect some of the charts displayed, not all of them.

I have a sheet in which you can filter by category, but I want to also include a chart which includes an overview of all the catetgories.

I'm used to using PowerBI where you can 'edit interactions' between filters and charts, looking for something similar.

Thanks

[trdandamudi · Accepted solution]

Please look into "Set Analysis" and this will allow you to disregard the selections based on chart.

[keithW]

Hi, thanks I think this looks to be the right idea but I'm struggling to make it work!

There are 2 filter panes on my sheet, 1 for category and 1 for retailer, I have a stacked bar chart showing counts of products for each retailer (Retailers on the x axis).  I need it to be filtered by the category selection, but not the retailer selection.

How do I use the set analysis function to disregard the retailer filter?  

[keithW]

Sussed it!

I was trying to add it to the dimension, not the measures.  Got it working now, works a treat.

Thanks