Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |