Matrix visualisation

[markvanoirschot]

Hi everyone,

I have an excel file with data like this:

Value A	Values connected
Red	Blue; Green; Purple
Green	Yellow; Blue
Red	Green
Yellow	Blue; Green; Red
Blue	Yellow; Red

Now i'd like to make a visualisation (Matrix) in which I see combination intensity between Value A and values B. For example with color intensity or something. How should i handle this within Powerbi?

Thank you a lot!

Regards, Mark

[Greg_Deckler]

Not sure I got that, but I am thinking you want to split out your Values connected column by semi-colon in Power Query and then unpivot the resulting columns.

[markvanoirschot]

Hi there Greg,

I'm actully looking for a matrix as in the screenshot. So that the intensity of the relation between items gets visible. I would have the colour names on both axes.

Thank you!