Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to 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!
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.
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.
By the way, a somewhat unrelated question. Do pie charts need to total to a 100%?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
142 | |
135 | |
110 | |
68 | |
55 |