Forum Discussion

Advocate II

8 years ago

Solved

Bar Chart by month with items with no data

Hello, I am trying to create a stacked bar chart where the x-axix is a date. I want to show a count by month over the last 12 calendar months, and show the months where there is no data (count = 0)...

Need Help

v-yulgu-msft
8 years ago
Hi huguest,

In that case, you can choose "months" rather than "calendar months" as shown in below screenshot.

Regards,

Yuliana Gu

huguest

Advocate II

8 years ago

Thank you, the solution is working (for now). I have under the impressiont that it will no longer work when I get into February and have to report on Feb2017 to Jan2018. As the x-axis shows only themonth an not the year, I will end up with Jan2018 as my first bar, then Feb through Dec2017...

v-yulgu-msft