Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
yohanhwang
Frequent Visitor

Would like to create column hierarchy in visual without transforming data

Hello everyone,

 

So I have the following table as shown:

What I currently haveWhat I currently have

I would like to categorize/group together some of the columns so as to have a column hierarchy as shown below. All the ones that start with "Disc" would go under the big column "Discovery" and then Discovery and some other would go under a bigger umbrella known as "Personal Visits" and so on... you get the idea. Ignore the fact that the numbers from the above do not match the numbers below. I would like to keep the numbers as they are (no transformations whatsoever). This is purely about creating a column hierarchy in a visual. But something that should be so simple seems so hard! I've found plenty of literature/posts about how to do something similar for the rows(like a multi index) but not for columns. If I do so on Python it does not translate as desired on the final output. Any help would be greatly appreciated!

desired outputdesired output

Would simply like to add column hierarchy without disrupting any of the data. The desired outcome would be something like this:

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.