Forum Discussion
How to get from Row to Matrix?
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
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.
2 Replies
- rajendraongole1
Super User
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
Helper I
Hi rajendraongole1 , that did the trick, thanks!!!!