Forum Discussion

KristofferAJ's avatar
KristofferAJ
Icon for Helper III rankHelper III
4 years ago
Solved

Data 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

 

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

4 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Unpivot this matrix, that's all.

  • sid_5005's avatar
    sid_5005
    Frequent Visitor
    2 years ago

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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      Hi,

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