Forum Discussion

pceglie's avatar
pceglie
Resolver I
9 years ago

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 cat...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

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's avatar
pceglie
Resolver I
9 years ago

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.