Column Hieararchy

[nmck86]

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

[danextian]

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

[nmck86 · Accepted solution]

I found an alternative... created a calculated column and called it main category and put each sub attitribute into an if equals then statement and will be using that.

[Ashish_Mathur]

Hi,

Change the visual to a matrix and show Attribute and Category in the Row labels itself.  Look at the second table.

[nmck86]

How will that give me a hierarchy between the data sets? I am wanting to start with repair satisfaction and then perform a drill down into the sub categories. Can you share an example we’re you make Repair Satisfaction the top of the hierarchy and I only see that attribute and then I see the sub attributes below it only as I drill through the data.

[Ashish_Mathur]

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.