Forum Discussion
Helper IIDrill Through Challange
Hello Friends,
Please refer link to the file.
https://drive.google.com/file/d/1gq5CinlSQu9qnN0aKdq-6cFJkeQrepLk/view?usp=sharing
I am using a matrix visual which has multiple measures, My drill through is not working,
Is there any way to set up drill through accurately so that if i can select the value of any measure in a table visual, i can drill through it to details page.
PowerRobots99
You can drill through the location and date, but not the measures. As power bi can't work out the calculation and drill through according to that.
Here is a workaroud that you can try if it fits your purpose.
https://community.fabric.microsoft.com/t5/Desktop/Drill-through-for-calculated-measure/m-p/1086091
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!There are only unsatisfactory workarounds in a Power BI report (I blogged about something similar here a few years ago https://blog.crossjoin.co.uk/2018/12/21/power-bi-drillthrough-complex-measures/) but if your users really need access to detailed data, using Analyze in Excel to connect to your Power BI semantic model is a much better solution because drillthrough on PivotTables supports the Details Row Expression, which gives you a lot more control. See https://selfservicebi.co.uk/hidden-features-of-analyze-in-excel-part-1-show-me-the-details/ for a good explanation of how it works.
4 Replies
NaveenGandhiMemorable Member
PowerRobots99
You can drill through the location and date, but not the measures. As power bi can't work out the calculation and drill through according to that.
Here is a workaroud that you can try if it fits your purpose.
https://community.fabric.microsoft.com/t5/Desktop/Drill-through-for-calculated-measure/m-p/1086091
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
cpwebbMicrosoft Employee
There are only unsatisfactory workarounds in a Power BI report (I blogged about something similar here a few years ago https://blog.crossjoin.co.uk/2018/12/21/power-bi-drillthrough-complex-measures/) but if your users really need access to detailed data, using Analyze in Excel to connect to your Power BI semantic model is a much better solution because drillthrough on PivotTables supports the Details Row Expression, which gives you a lot more control. See https://selfservicebi.co.uk/hidden-features-of-analyze-in-excel-part-1-show-me-the-details/ for a good explanation of how it works.
- NaveenGandhi
Hi PowerRobots99
Drill through by measure is not possible. You can only achieve it through column fields, In your example location and report date will trough as expected.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Follow me on LinkedIn!!!
PowerRobots99Are you sure?,
If we cant drill through, then what is the use of just displaying numbers by using calculated mesures?