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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

drill through

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? Screenshot 2023-07-01 215007.pngScreenshot 2023-07-01 215617.png

1 ACCEPTED SOLUTION
rbriga
Impactful Individual
Impactful Individual

This isn't exactly a drillthrough, and may be better addressed as a tooltip page which will display on hover.

With that said:

  1. Click on your bar chart
  2. In the toolbar, click Format->Edit interaction
  3. With the bar chart still selected, switch the interaction mode on the pie chart from "highlight" to "filter" (see screenshot)Switch to filterSwitch to filterVictory!Victory!
-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

View solution in original post

2 REPLIES 2
rbriga
Impactful Individual
Impactful Individual

This isn't exactly a drillthrough, and may be better addressed as a tooltip page which will display on hover.

With that said:

  1. Click on your bar chart
  2. In the toolbar, click Format->Edit interaction
  3. With the bar chart still selected, switch the interaction mode on the pie chart from "highlight" to "filter" (see screenshot)Switch to filterSwitch to filterVictory!Victory!
-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!
Anonymous
Not applicable

Appreciate you so much! Thank you

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.