Matrix with same rows and columns

[LarryFisherman]

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,

[HotChilli]

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?

[HotChilli]

Can you provide the source data for this end result please?

[LarryFisherman]

Hi, I have updated the post with some sample data.

Thanks for pointing out.