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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Guru123
Frequent Visitor

PowerBI Matrix table - column name group

dear Friends,

How do we group columns name in the powerbi matrix table as in this screenshot.

 

Guru123_1-1705980055135.png

 

any help please.

 

Thanks!

 

 

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Guru123 
If I understood you correctly you can achieve it with calculated groups, please refer to the linked video:
https://www.youtube.com/watch?v=q-zFoQfBHXM&t=8s

If not 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Guru123
Frequent Visitor

dear Friends,

I use calculated group in the report and it's now grouping 

 

Guru123_0-1707383643605.png

but when I bring the calculated group down one level, the group is not working. it showing 

Guru123_1-1707383906932.png

In matrix table : 

Guru123_2-1707383938203.png

 

any help please. Thanks a lot

 

Guru123
Frequent Visitor

Thanks Ritaf1983, something like this.

 

but I would like to have as in this screen2, is this possible pelase. thanks a lot

 

Guru123_2-1706171375701.png

 

 

Ritaf1983
Super User
Super User

Hi @Guru123 
If I understood you correctly you can achieve it with calculated groups, please refer to the linked video:
https://www.youtube.com/watch?v=q-zFoQfBHXM&t=8s

If not 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors