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
kala2
Helper III
Helper III

How to create a matrix grouped by categories based on multiple columns

I want to create a matrix like the following example:

Screenshot 2021-08-04 130428.png

I have the following table with dummy data:

Projekt IDProjektnameStatus GesamtProbleme GesamtStatus ZeitProbleme Zeit Status BudgetProbleme BudgetStatus PersonalProbleme Personal
PR-01Projekt 1grünprobleme gesamt 1grünprobleme zeit 1rotprobleme budget 1grünprobleme personal 1
PR-02Projekt 2gelbprobleme gesamt 2rotprobleme zeit 2gelbprobleme budget 2grünprobleme personal 2
PR-03Projekt 3grünprobleme gesamt 3grünprobleme zeit 3grünprobleme budget 3gelbprobleme personal 3


I want to create four categories: Gesamt, Zeit, Budget, Personal

In power bi i have unpivoted correctly the Statuses columns and the result is:

kala2_0-1628072323940.png

The matrix now, shows correctly the first column.

Screenshot 2021-08-04 132528.png


Any ideas how to make the Second Problem column? I tried to unpivot this aswell but i dont know how to implement into the matrix

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

what values are you expecting for the second column?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






If in my filters i have selected all the projeckts then the matrix will show probleme budget 1, probleme budget 2, probleme budget 3

If in the filters i have selected i.e Projekt 1 then in the matrix will show probleme budget 1 e.t.c

kala2_0-1628077712547.pngkala2_1-1628077722507.png

 

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.

Top Solution Authors