Forum Discussion
Matrix with same rows and columns
Hi,
I am trying to create below visual, but I can't seem to make it work with either a table or a Matrix:
The columns and rows are the same, and the number is the count of cases in each category. A case can have more than 1 category.
| Category 1 | Category 2 | Category 3 | Category 4 | Category 5 | |
| Category 1 | 1 | 6 | 3 | 3 | 5 |
| Category 2 | 8 | 2 | 7 | 1 | 3 |
| Category 3 | 5 | 3 | 3 | 4 | 4 |
| Category 4 | 5 | 1 | 2 | 5 | 2 |
| Category 5 | 3 | 1 | 3 | 9 | 9 |
My data looks like this:
| Case ID | Category |
| 1 | Category 1 |
| 1 | Category 2 |
| 1 | Category 3 |
| 1 | Category 4 |
| 2 | Category 4 |
| 2 | Category 3 |
| 3 | Category 2 |
| 3 | Category 1 |
| 4 | Category 2 |
| 4 | Category 1 |
How do I achieve this in Power BI?
Thanks in advance,
3 Replies
Can you provide the source data for this end result please?
Let's keep it simple. The original data and the desired result should reflect each other (with an explanation of how to get from one to the other).
So let's start with the sample data. What would the end result be and how do we get there?
