Forum Discussion
Apply Drill Down to a specific bar
Can I include a drill down to a particular bar in a bar chart, if yes then how should I do it?
Hi Akashnegii ,
Below is the sample data using for drilldown usecase:
1.Create a Clustered Bar Chart
2.Go to Visualizations pane and select Clustered Bar Chart.
3.Drag Category into the Shared Axis field.
4.Drag Sales into the Column Values field.
5.To add Drill Down Hierarchy please drag Subcategory and drop it below Category in the Shared Axis field.
6.Now you have hierarchy Category → Subcategory.
7.Drill Down into a Specific Bar please click on arrow as per screenshot.8. After clicking on Furniture bar,we can see the drill down for that particulart bar.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
5 Replies
- Idrissshatila
Super User
Hello Akashnegii ,
the drill down functionality works for all the chart, it can't be specified for only one bar.
but you can drill through on one bar and go to another page where you can see details regarding this bar only.
check drillthrough in Power bi https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
- grazitti_sapna
Hi Akashnegii ,
Below is the sample data using for drilldown usecase:
1.Create a Clustered Bar Chart
2.Go to Visualizations pane and select Clustered Bar Chart.
3.Drag Category into the Shared Axis field.
4.Drag Sales into the Column Values field.
5.To add Drill Down Hierarchy please drag Subcategory and drop it below Category in the Shared Axis field.
6.Now you have hierarchy Category → Subcategory.
7.Drill Down into a Specific Bar please click on arrow as per screenshot.8. After clicking on Furniture bar,we can see the drill down for that particulart bar.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
v-dineshyaCommunity Support
Hi Akashnegii ,
Thank you for reaching out to the Microsoft Community Forum.
Hi grazitti_sapna and Idrissshatila , Thank you for your prompt responses.
Hi Akashnegii , Could you please try the proposed solutions shared by grazitti_sapna and Idrissshatila ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
- v-dineshya
Hi Akashnegii ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
- v-dineshya
Hi @Akashnegii ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
