Stacked Column Chart - swap x-axis and y-axis

[Anonymous]

I am trying to recreate a chart from Excel into Power BI, but I am having trouble getting the x-axis and y-axis to be the same as my original chart. The location should be stacked and months run along the x-axis. Anyone no if this is possible?

Data set:

Data Set

Excel:

Excel Original

Power BI:

Power BI

[v-lili6-msft · Accepted solution]

hi @Anonymous 

From your screenshot, we could know that your data structure is this:

So you need to transform your data structure as below:

Step1:

In edit queries, Selected Dec-Total,Jan-Total,Feb-Total... 

Then click Unpivot columns

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

Step2:

Now create visual, drag Attribute column in X-Axis, Location into Lenged and Value into Value

and here is sample pbix file, please try it.

Regards,

Lin

[VasTg]

@Anonymous 

You should move "location" to legend, "month" column(if any - if not create one) to Axis and the single "total" column to Value.

If it helps, mark it as a solution.

Kudos are nice too.

[Anonymous]

@VasTg 

Not sure if I'm following. My month values are already in the value input which is a column.