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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gabychr
Regular Visitor

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!

Appreciate you so much! Thank you

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors