Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Below there is a file that I would love to build a hiearchy off of. It would be based on the Attribute field. Really for an example you can build a hieararchy between Repair Satisfaction and maybe 5 of the other categories.. However, I would like for me to be able to start my visual off with just showing Repair Satisfaction and then drilling down into the 5 sub categories and the details related to those... any ideas on that?
https://drive.google.com/open?id=14S4YG2X80ueSp3tMl0wqnBVUXfvIfJ0P
Solved! Go to Solution.
Or maybe instead of drilling down, you want to use a dynamic category such that when you click an item in the slicer, the column items in the table change. If that is the case, you might want to check out this: https://community.powerbi.com/t5/Desktop/Dynamic-Category-Using-a-Slicer/m-p/318119
Proud to be a Super User!
Hi,
Change the visual to a matrix and show Attribute and Category in the Row labels itself. Look at the second table.
Hi,
That is exactly what the matrix visual achieves. When you click on the drill down button in the visual, you will see the second attribute.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |