Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
So I have the following table as shown:
What 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 output
Would simply like to add column hierarchy without disrupting any of the data. The desired outcome would be something like this:
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.