How to get from Row to Matrix?

[BIntelligence]

Hi, I'm not new to PowerBI, but at this moment I have a request I cannot solve with my knowledge.

I have a dataset with a row like on the upper side of the image below.

It must be presented like the green table, so in a Matrix visual.

How could this be achieved? Using the Table Editor or so?

Hope someone can point me in the right direction.

Thanks in advance!

Maurits

[rajendraongole1 · Accepted solution]

Hi @BIntelligence  -you can try unpivot your columns in Power Query and then build a calculated column or measure to show the Difference.

Please find the attached pbix file.

Hope this helps.

[BIntelligence]

Hi @rajendraongole1 , that did the trick, thanks!!!!