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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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!

 

 

 

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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