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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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!
Imagem de fundo



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!
Imagem de fundo



Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.