Filtering by 2 criteria

[pceglie]

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,

[Greg_Deckler]

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?

[pceglie]

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

[Greg_Deckler]

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":

http://community.powerbi.com/t5/Data-Stories-Gallery/Ohio-Primary-and-Secondary-Education-Performanc...

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.

[pceglie]

You're right!

But how can I add a column (measure) that refers to that filter (the second one)?

[v-yulgu-msft]

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 Gu

[pceglie]

Hi @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.

[Greg_Deckler]

Then you add that column (the one that is interested) as your slicer?