Forum Discussion
Filtering by 2 criteria
Hi, I have a report with a Slicer:
1. filter Year
2. filter Month
3. filter ProductCategory (single value selected)
the report contains a list of customers with total Revenue per selected category and it works well.
The question is: how can I add a filter to perform a compare from the selected Category and another one (prompted by user) keeping the filter on Yer/Month/Customer?
Thanks,
7 Replies
I am not clear on what you are trying to do. Can you post some sample data and your expected result, perhaps some mocked-up screen shots?
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.
