I have a bar graph with all the ncaa conferences and the times that they have appeared in the top 20. Next to it I have a pie chart. I want the user to be able to click on a conference and then the pie chart will display the universities in that conference and the percentage that each university has appeared in the top 20. How do i achieve that?
This isn't exactly a drillthrough, and may be better addressed as a tooltip page which will display on hover.
With that said:
- Click on your bar chart
- In the toolbar, click Format->Edit interaction
- With the bar chart still selected, switch the interaction mode on the pie chart from "highlight" to "filter" (see screenshot)
Switch to filter
Victory!.
This isn't exactly a drillthrough, and may be better addressed as a tooltip page which will display on hover.
With that said:
- Click on your bar chart
- In the toolbar, click Format->Edit interaction
- With the bar chart still selected, switch the interaction mode on the pie chart from "highlight" to "filter" (see screenshot)
Helpful resources
Power BI Monthly Update - November 2023
Check out the November 2023 Power BI update to learn about new features.
The largest Power BI and Fabric virtual conference
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.
