Forum Discussion
How to create stacked column chart
Hi, I'm new to Power BI and still learning the basics. I'm not familiar with pivot tables in Excel so I'm having quite a hard time migrating from Excel to Power BI.
I'm trying to create a stacked column chart like the 1 below
Using this raw data I have
With Excel, I could easily do it in a few clicks but I can't figure out what do I need to do to get the same chart in Power BI.
What do I need to input into the visual fields to get the result I want?
Do I need to reformat the raw data into something different?
Thanks for the help!
Anonymous , ideal is you unpivot the columns 1 to 15. If not you have to take all of them as values the first column as axis.
You can use stacked line visual
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart
1 Reply
Anonymous , ideal is you unpivot the columns 1 to 15. If not you have to take all of them as values the first column as axis.
You can use stacked line visual
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart