Forum Discussion
KristofferAJ
Helper III
Helper IIIData for "Overlap matrix"
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
Unpivot this matrix, that's all.
4 Replies
CNENFRNLCommunity Champion
Unpivot this matrix, that's all.
KristofferAJThat was prompt! and exactly what I needed...! thanks
I also have a similar usecase.Can you please elaborate more on the solution.
Thanks.- Ashish_Mathur
Super User
Hi,
The proposed solution is that In the Query Editor, you right click on the Same Color? column and click on "Unpivot Other Columns".
