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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
lt79_Pax
Helper II
Helper II

Drill through using Header table and Detail table within a Snowflake Schema

Dear Power BI Representative,
I have a data model containing an aggregated header fact table connected to a detail layer fact table joined by a key field.
I have two pages. One page contains the header visulization based on the header fact table and the second page contains the detail visualization based on the detail table.
I currently have the aggregated metric from the header table on the detail page under the drillthrough section as a summarized drill through
however when I go to the header visualization and select the drill through using the aggregated metric, the detail page drill through filters populate
based on the header filter contexts on the far right however the detail visualization outputs all records instead of those based on the header drill through filter contexts.
Is it possible to drill through with header to detail visualizations when each visualization originates from two separate tables in the data model? If so,
could you please tell me what I am missing in this approach?

Thank you.

1 REPLY 1
amitchandak
Super User
Super User

@lt79_Pax , There is a hack for it. Drill through using card visuals. See if that can help or give new idea achieve what you want

https://www.youtube.com/watch?v=VBRUiGeV6I4

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.