Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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:
Solved! Go to Solution.
@alottawarmh , Unpivot the four columns demand type, demand, and other in power query
https://radacad.com/pivot-and-unpivot-with-power-bi
@alottawarmh , Unpivot the four columns demand type, demand, and other in power query
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!