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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
ChrisAZ
Helper V
Helper V

Change visual for selection

Hello,

 

I am wanting when I click on a value or column in another graphic on my dashboard to change the pie chart to display the percentages to show the percentages based on the item selected, and not show it as a percentage of the total. For example, when I click on Jan 2025 in the bottom chart, instead of graying out a bunch of the pie chart above, I want it to change the values to be the percent for each task in January so the pie chart totals to 100% for the selection I made. Or if I click a mechanic on the left side, it would show their breakdown of their tasks by percentage to also equal 100% of their work.Screenshot 2025-02-14 140702.png

1 ACCEPTED SOLUTION
Tutu_in_YYC
Super User
Super User

Try Edit Interation and change it to Filter.

Tutu_in_YYC_0-1739571250973.png

 

View solution in original post

2 REPLIES 2
Tutu_in_YYC
Super User
Super User

Try Edit Interation and change it to Filter.

Tutu_in_YYC_0-1739571250973.png

 

That is perfect. Thank you!

Helpful resources

Announcements
Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.