How to create stacked column chart

[Anonymous]

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!

[amitchandak · Accepted solution]

@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