Forum Discussion
Filtering by 2 criteria
Hi, look at the example below
I need a column in the table that contains the total Qty ordered by second filter-
So I need to analyze the total Qty ordered for the year 2016, and for filter SIZE1 = 1.5m and I need to compare the same value for the filter 2 (for example Size = 10m)
The problem is that when I apply the filter SIZE1 obviously SIZE2 is just filtered too.
How can I obtain the desired result?
Thanks
Got it. Use "Edit Interactions". So click your size slicer, in ribbon under Visual Tools, click "Format". On the far left is "Edit Interactions". When you do this, you will see little icons appear on all of your other visualizations. Click on the "Ghostbuster" icon to turn it off on the visuals you do not want to be affected by selections on the selected visualization. I use this extensively on the second page of my data story "Ohio Primary and Secondary Education":
Note, in your case, I imagine that you would have 2 identitical tables. Year would filter both. Your first size would only filter your first table. Second size filter would only filter your second table.
You're right!
But how can I add a column (measure) that refers to that filter (the second one)?
Hi pceglie,
Do the slicer SIZE1 and SIZE2 contain the exactly same options? That is to say you added the same column to these two filters. If so, now you want to analyze the total Qty ordered for the year 2016 under SIZE = 1.5m and SIZE = 10m, why don't you consider to use only one slicer and enable multiple selections.
Turn off the Single Select. Then you can select both SIZE = 1.5m and SIZE = 10m in slicer and the filtered data you want to compare will display in the same table visual.
If you still have any question, please feel free to ask.
Best regards,
Yuliana GuHi v-yulgu-msft, this is only an example. The real report is more complex than this. I can't use multi-select on the slicer because I need only one column of the table (the last one) will be interested by the second slicer.
