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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors