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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

Drill Through: how can I drill through to all data without filtering on a "slice" of the visual?

If I have a bar chart showing sales by year, how can I go to a Drill Through page WITHOUT having to select a bar?

Instead of clicking 2022 for Sales, I want to drill to see ALL the sales.

If I right click (without left clicking a bar first) it will still drill through for whatever item I was hovering my mouse over.

Is there a way to drill through but NOT apply a filter from the visual "slice"?

*I want to still be ABLE to drill through by clicking a bar or "slice" but I want to have the option to do either.  Left click first to select then drill through using that selection OR right click without selecting and get all data.

1 REPLY 1
djurecic
Super User
Super User

Hi @OneWithQuestion ,

 I don't think this is possible- seems similar to this idea:

https://ideas.powerbi.com/ideas/idea/?ideaid=61accd5c-baa6-4a40-99e2-79f1ee837bd4

 

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.