Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 .
Solved! Go to Solution.
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |