Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

100% Stacked Column Chart Continuity Issue (In terms of months and year)

Hello Everyone,


I am currently updating a report which has several 100% stacked column charts. I update these charts on a monthly basis and everything had been going well until I did the refresh for the month of January 2017. As you can see from the attached image, I have completed the data refresh for all months of 2016. However, when I attempt to refresh for January, then there is a problem with the continuation. 


Can anyone please offer some guidance on how to keep the continuity going without January 2017 combining with January 2016 and so on and so forth? 


Thank you!




Community Champion
Community Champion

For the date field that you are using as the X axis, make sure "Date Hierarchy" is selected, remove Qtr and Day (you'll be left with Year and Month), and then drill to the lowest level of the chart (the two-pronger double-arrow in the top left).  You can then play with the formatting settings of the X axis to have it display how you would like.
















If you have a date table in your model, be sure you use the date field from there.


Hope this helps



Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors