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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.