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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
PCarson00
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?

 

PCarson00_0-1700068916939.png

 

 

2 REPLIES 2
Anonymous
Not applicable

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?

 

PCarson00_0-1700130566913.png

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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