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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors