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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
udian
Helper III
Helper III

Drill Through Doesn't Pass Measure Filters

Hi,

 

I am trying to use drillthrough in my PBI report.

 

I have the folowing table:

Capture.JPG

when i press drillthrough on the cell where # PMTs Range 1 = 20 the drillthrough passes the activity category and activity sub category correctly, but it ignores the filter in the measure that filters on Range = 1 and then the drillthrough report brings me results for all 65 payments of category = A and sub category = A2 (20+22+23 = 65).

 

can someone explain this behaviour?

 

*The # PMTs measures are 3 different measures.

 

Thanks!

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @udian,

 

Please be aware of that in Power BI, filter is worked based on row leve, rather than column level. The same as slicer, Drill Through filters visual with the passed value which is the detailed value under column rather than column/measure header. It is a by design behavior.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @udian,

 

Please be aware of that in Power BI, filter is worked based on row leve, rather than column level. The same as slicer, Drill Through filters visual with the passed value which is the detailed value under column rather than column/measure header. It is a by design behavior.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

So there is no option for me to get the drill down to the specific measure value that i wnat?

 

Thanks!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

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