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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Tshafer61
New Member

pie chart percentages when filtered

I am relatively new to Power bit.  I am working with a Pie Chart to show categories percentages for answers to a questionnaire  and using a treemap to to filter on location.  When I click on a location in the treemap, the Pie chart shades, showing percentage of that category for the location against the total.  What I want to happen is for the percentages to show their part of the total, for that location (that location would = 100%).  Any thoughts?  Below is what it currently looks like  .Pie Percent.JPG

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Check out the topic "Group interactions among visuals"

 

https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations?tutorial-step=13#step-13

 

What you will need to do is select the treemap, go to "Format" in your ribbon, click "Edit interactions."

Then, when you hover your cursor over the pie chart, you will see some small gray icons in the top right of the visual. Select the icon that's labeled "Filter." THen you can unselect the "Edit interactions" mode and try out filtering your pie chart with your treemap.

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Check out the topic "Group interactions among visuals"

 

https://docs.microsoft.com/en-us/power-bi/guided-learning/visualizations?tutorial-step=13#step-13

 

What you will need to do is select the treemap, go to "Format" in your ribbon, click "Edit interactions."

Then, when you hover your cursor over the pie chart, you will see some small gray icons in the top right of the visual. Select the icon that's labeled "Filter." THen you can unselect the "Edit interactions" mode and try out filtering your pie chart with your treemap.

 

This worked perfectly.  Thanks for the help!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.