cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Use multiple slicers to filter different fields in same table

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?

1 ACCEPTED SOLUTION
ManNVSM
Resolver II
Resolver II

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.

 image.png

 

View solution in original post

4 REPLIES 4
ManNVSM
Resolver II
Resolver II

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.

 image.png

 

Anonymous
Not applicable

@ManNVSM

 

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

Glad to hear that 🙂

 

Regards,

ManNVSM.

Hi @ManNVSM 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/2504...

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.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors