Forum Discussion
Clustered stacked column chart
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?
You need to select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.
3 Replies
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
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?
v-chuncz-msftCommunity Support
You need to select the third icon "Expand all down one level in the hierarchy" in the top left corner of the visualization.
