Forum Discussion

huguest's avatar
huguest
Icon for Advocate II rankAdvocate 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's avatar
    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

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi huguest,

 

Based on the steps mentioned in my original post, please change the axis type to "Categorical". Then, change [Date] field to "Hierarchy".

 

Best regards,

Yuliana Gu

 

huguest's avatar
huguest
Icon for Advocate II rankAdvocate 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's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi huguest,

     

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

     

    Regards,

    Yuliana Gu