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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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.

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

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors