Drill Down on Pie Chart after Selecting Slicer

[pgo]

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.

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

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

[Idrissshatila]

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.

[pgo]

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?

[Anonymous · 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!

[pgo]

Hi @Anonymous,

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.

[Anonymous]

Glad to know it works! Thank you too 😄

[pgo]

Great find. I'll go have a read.

[pgo]

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