Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Russ99
Helper I
Helper I

Slicers vs filters from visualisations

Dear Community,

 

I have built a basic dashboard, on the left side I have a filter pane where users can select a product category etc etc. I have a set of visualisations in the middle of the dashboard that change when items from the slicers are selected. I have a pie chart for "category" and a bar chart for "sub category". If i click a category in the pie chart, all subcategories are still on the bar graph even the sub categories not part of the category i have clicked. The subcategories that are part of the category selected are bold and easy to see and the other subcategories are greyed out, however I want them not to dilute the visual as I have to scroll down to see the sub categories i want. When i use the slicer to select a category, only the relevant sub categories stay in the sub category bar chart. Is it possible to have this slicer effect happen when a visualisation is clicked. In a perfect world, when i click "Accessories" on the pie chart, only belts, handbags, cufflinks etc would appear in the bar chart. Not other items that are part of the "t-shirt" category.

 

thanks so much for your help

 

Russ

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Russ99 , I think you need to change interaction to filter

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

 

Intract Fill.pngIntract Filter.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Russ99 , I think you need to change interaction to filter

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

 

Intract Fill.pngIntract Filter.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors