Creating Matrix with Different Columns

[alottawarmh]

Hello everyone,

I have an issue with creating a visual. My data is coming from an excel sheet to Power BI as you can see below. What I want is, I want to create a visualization which can be seen on 2nd image. I've tried to use both table and matrix visualizations but I couldn't manage to create the exact visual. Should I change my data table? Or is there a way to achieve this? Thank you!

Data:

Visual I want to achieve:

[amitchandak · Accepted solution]

@alottawarmh , Unpivot the four columns demand type, demand, and other in power query

https://radacad.com/pivot-and-unpivot-with-power-bi

[alottawarmh]

Hi @amitchandak thanks for the article, after I pivoted demand type as the name, and demand as value, I achieved the final view by also using measures. Thank you!