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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
PowerRon
Post Patron
Post Patron

Drill through in matrix possible?

Hi

on my report I have a matrix.
In the rows a country name, in the columns dates. Max fifteen dates are shown.


Unfortunately I can't drill through to another page from a date from the matrix, like the one with the red circle

Knipsel.JPG

 

I also can't drill through from a slicer. Also not when I create a button with Action Drill through and link it to a page with Date as drill through field. I can only drill through from a table.

What is a nice way to select one of the fifteen dates and go to a page giving more detailed information about that date?

 

Thnx

Ron

1 ACCEPTED SOLUTION
marcelsmaglhaes
Super User
Super User

Hey @PowerRon !

 

I tested the DrillTrough here and it works. In image 1 I have the principal Matrix. I chose the second date 10/01/2018 (image 2) and drill to Page 2 (image 3). 

 

Take a look how to set the DrillTrough here: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

 

Best Regards,
Marcel


Image 1

marcelsmaglhaes_0-1676059971887.png

 

Image 2

marcelsmaglhaes_1-1676060065458.png

 

Image 3

marcelsmaglhaes_2-1676060100253.png

 

 

 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



View solution in original post

2 REPLIES 2
PowerRon
Post Patron
Post Patron

Hi @marcelsmaglhaes 

 

I started all over again and got it working. Probable I was misconfused somewhere.
Thnx a lot for helping me out. Enjoy the weekend!

Regards
Ron

marcelsmaglhaes
Super User
Super User

Hey @PowerRon !

 

I tested the DrillTrough here and it works. In image 1 I have the principal Matrix. I chose the second date 10/01/2018 (image 2) and drill to Page 2 (image 3). 

 

Take a look how to set the DrillTrough here: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

 

Best Regards,
Marcel


Image 1

marcelsmaglhaes_0-1676059971887.png

 

Image 2

marcelsmaglhaes_1-1676060065458.png

 

Image 3

marcelsmaglhaes_2-1676060100253.png

 

 

 


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors