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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |