Clustered stacked column chart

[shiner1]

Hello

I have a question when adding mulitple years months in a bar chart the previous years month totals to one month. Like say you wanted to look at September 2016- September 2017 actual sales for the month. The month of September will be bigger than all the other months because Power Bi totals 2016+2017. Does anyone know how to fix this?

[v-chuncz-msft · Accepted solution]

@shiner1,

You need to select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.

[shiner1]

I have the data in month-year format from 2008 to 2017. I have the drill down turned on to go year, quarter, month. Not sure if power bi is only set to show one year 12 columns?

[j567boston]

Wouldn't you just make the axis Month - Year instead of just Month so you break it out into 13 columns and not 12?

-J