cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmck86 Member
Member

Column Hieararchy

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

1 ACCEPTED SOLUTION

Accepted Solutions
nmck86 Member
Member

Re: Column Hieararchy

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.

View solution in original post

5 REPLIES 5
Super User
Super User

Re: Column Hieararchy

Hi,

 

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

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
nmck86 Member
Member

Re: Column Hieararchy

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.
Super User
Super User

Re: Column Hieararchy

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
danextian New Contributor
New Contributor

Re: Column Hieararchy

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
nmck86 Member
Member

Re: Column Hieararchy

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.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,650)