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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
pgo
Frequent Visitor

Drill Down on Pie Chart after Selecting Slicer

Hi Guys,

 

I am working with a pie chart. And I am wondering if I there is a way I can drill down the view of the pie chart after choosing a selection on the slicer.

pgo_0-1718878888768.png

Right now, if I select a slicer. It just shows the whole pie. Then, I have to click the pie chart to drill down.

pgo_1-1718879026573.png

Is there a way to show the drilled down visual instead?

pgo_2-1718879092193.png

 

1 ACCEPTED SOLUTION

Hi @pgo 

 

I found a blog, which seems to meet your requirement. But you will probably have to modify the table structure. 

Drill Down Using Slicer in Power BI (octanesolutions.com.au)

 

Additionally, as you only have three values in the parent level category, another option is to create bookmarks to switch the visuals. Create four bookmarks, one for the overall parent-level pie chart, the other three for the child-level pie chart but filters it with different category values. Then use buttons or bookmark navigator to switch between bookmarks. 

Toggle Between Charts in Power BI - Microsoft Fabric Community

Create page and bookmark navigators - Power BI | Microsoft Learn

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

View solution in original post

7 REPLIES 7
Idrissshatila
Super User
Super User

Hello @pgo ,

 

so you mean when you click on a specific filter in the slicer it drill down by default ?

 

it won't work like this, but you can make another visual that you can have the drilled down filed with the value so when you filter in the slicer it will show the impact on the other field.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Yeah, I was hoping there was built-in option for the drill down. How can I switch up the charts when I click on the specific filter?

Hi @pgo 

 

I found a blog, which seems to meet your requirement. But you will probably have to modify the table structure. 

Drill Down Using Slicer in Power BI (octanesolutions.com.au)

 

Additionally, as you only have three values in the parent level category, another option is to create bookmarks to switch the visuals. Create four bookmarks, one for the overall parent-level pie chart, the other three for the child-level pie chart but filters it with different category values. Then use buttons or bookmark navigator to switch between bookmarks. 

Toggle Between Charts in Power BI - Microsoft Fabric Community

Create page and bookmark navigators - Power BI | Microsoft Learn

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Hi @v-jingzhan-msft,

I tried the Drill Down Using Slicer in Power BI. It works for my model. It took some time to understand the method. It would have been easier to perform bookmark, but I wanted to try the first method you provided.

Thanks.

Glad to know it works! Thank you too 😄

Great find. I'll go have a read.

pgo
Frequent Visitor

By the way, a somewhat unrelated question. Do pie charts need to total to a 100%?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.