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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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