Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
Solved! Go to Solution.
@Russ99 , I think you need to change interaction to filter
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
@Russ99 , I think you need to change interaction to filter
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions