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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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