Skip to main content
cancel
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

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
Power5
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?

 

PCarson00_0-1700130566913.png

 

Helpful resources

Announcements
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.