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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Grouping multiple columns together

I have a stacked chart that has lots of columns and is difficult to read.


These columns also have a heirarchy above them, so can be grouped into less chunks. In the excel document, this is a merged cell above the column headers.


Is there a way to include these or by way of using filters to gather these together?





Helper IV
Helper IV

Hello @PCarson00 ,


What you can do is just make a measure that Sums all those different parts together. EX. GROUP 1= SUM(A) + SUM(B) + SUM(C) + SUM(D) / EX. GROUP 2 = SUM(D) + SUM(E) + SUM(F) + SUM(G)

Thanks that has worked but is there a way to drill down on those fields now. If I click on those columns, would it be possible to see what thats made up of, or have a list with those specific skills that once clicked, would break it down?




Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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