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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |