Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table with subcodes in the columns such as 0.1, 0.1.1, 0.1.1.2 below:
I also have the column, Currrent Spend, which contants the values which I want to show in my visualisation.
I have put my subcode columns, Cat2, Cat3 and Cat4 into the drill through section in the Visualisations pane, however I do not see the drill-through option when I right-click on one of my categories described here, https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough.
Can somebody explain to me how this drill-down option is meant to work?
I was hoping to expand my Cat1 category into the Cat2 category, for example, to see the current spend for 0.1 (toxic/hazardous/contaminated materials ) and 0.2(major demolition works) and other subcategories.
Thank you.
Solved! Go to Solution.
Drill through is meant to go from one page to another. You want to add the Cat 2, Cat 3, and Cat 4 into the matrix and use drill down.
Or you can right click on a bar and drill down.
Drill through is meant to go from one page to another. You want to add the Cat 2, Cat 3, and Cat 4 into the matrix and use drill down.
Or you can right click on a bar and drill down.
I do not see the drill down option when I click on a bar. I have just added a matrix under it, and added Cat1, Cat2 and Cat3 into Rows, Current spend into Values.
here it is:
yes, I can drill down through this matrix now yet I still do not have the drill down option when I click on one of the bars. I have created a link to my file, https://1drv.ms/u/s!AtS3DN4JGKISiCX5t-51djzyLAGj?e=YOxyBH
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |