Use multiple slicers to filter different fields in same table

[Anonymous]

Hi, 

I want to create a summary report which will be displayed on screen in my office. 

The report will contain data which is being fetched from other 4 reports. I am able to make 4 different tables but I want align all 4 tables with different filters (slicers) each and Combine them into a single report.

Any suggestion how to do that?

[Anonymous · Accepted solution]

Dear @Anonymous,

Sure, you can do it.

• Create new Filter, go to Tab "Format" > Edit Interactions.
• Click on Filter you want to make filter for what analysis. (See my picture for exam: Filter Achieved value just Filter for the Bar chart, the Pie chart won't do anything)
• Then make another Filter, Disable with Bar and Filter with Pie.

Regards,

ManNVSM.

 

[Anonymous]

@Anonymous

Thank you so much for the help. It actually works. 

[Anonymous]

Glad to hear that 🙂

Regards,

ManNVSM.

[Anonymous]

Hi @Anonymous can I use this method for my problem here: https://community.powerbi.com/t5/Desktop/How-can-I-show-the-results-of-one-slicer-at-a-time/m-p/2504533

? 

I tried your solution, but only one slicer works and the other two does not show the right data in the table. Could you please advise? Thanks.