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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Mahadev
Frequent Visitor

Drill through function not working properly in one page.

Hi all,

 

Can someone help me with this.

I'm using matrix visual in a page where i used drill through funtion.

But when i click on drill through funtion on any value in matrix visual then it is not working properly.

But for all other pages drill through function is working fine.

Can someone tell me cause of this issue and how to rectify.

 

Thanks

 

4 REPLIES 4
Idrissshatila
Super User
Super User

Hello @Mahadev ,

 

it depends where are you clicking, its taking the filters with it, so if you'r clicking in a value for a certain row in a certain column, and there are filters affecting the visual or the page, then drill through takes the filters with it.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Hi @Idrissshatila 

Thanks for your quick response.

There are no filters applied in my drill through page. 

For all other pages i'm using the same drill through page.

For other pages drill through option is working absolutly fine.

let me explain you indetail.

Mahadev_0-1699351498608.png

If i click on any single digit value and drill through on that value then in drill through page i have to get only 5 detailed information. but when i drill through on that value i'm getting all the data for that month. no filters applied any where in the page.

 

Thanks.

amitchandak
Super User
Super User

@Mahadev , what is not correct? When you drill through from Matrix it will pass all the column fields and row fields applicable at that time

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

 

Power BI Drill Through when Userelationship is used in a Measure- https://youtu.be/1BM_WGATrQA

 


Appreciate your Kudos.

Hi @amitchandak 

Thanks for your quick response.

There are no filters applied in my drill through page. 

For all other pages i'm using the same drill through page.

For other pages drill through option is working absolutly fine.

let me explain you indetail.

Mahadev_0-1699362899825.png

 

If i click on any single digit value and drill through on that value then in drill through page i have to get only 5 detailed information. but when i drill through on that value i'm getting all the data for that month. no filters applied any where in the page.

 

Thanks.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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