Forum Discussion

kala2's avatar
kala2
Icon for Helper III rankHelper III
5 years ago

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

I want to create a matrix like the following example:



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:

The matrix now, shows correctly the first column.


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

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

    • kala2's avatar
      kala2
      Icon for Helper III rankHelper III
      5 years ago

      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