Data for "Overlap matrix"

[KristofferAJ]

Hi, 

I simply can't get my head around how I can build my raw data to be able to show following example in powerBI:

In essense I want to have matrix which can show overlap - but how should my raw data look?

I would appreciate any input or tips

Thanks

Kristoffer

[sid_5005]

I also have a similar usecase.Can you please elaborate more on the solution.
Thanks.

[Ashish_Mathur]

Hi,

The proposed solution is that In the Query Editor, you right click on the Same Color? column and click on "Unpivot Other Columns".

[KristofferAJ]

That was prompt! and exactly what I needed...! thanks

[CNENFRNL · Accepted solution]

Unpivot this matrix, that's all.