Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hi,
I am trying to use drillthrough in my PBI report.
I have the folowing table:
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!
Solved! Go to Solution.
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
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
So there is no option for me to get the drill down to the specific measure value that i wnat?
Thanks!
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |