displaying a zero value on a bar chart

meadow_ryan
meadow_ryan Member
in Charting

If I have a bar chart where I'm graphing the volume of something monthly and one of the months doesn't have any data so the bar displays, Jan 2016, Feb 2016, Mar 2016, Apr 2016, then May is missing.....

 

Can I zero value be shown in any way?

 

thanks for any help provided

Best Answer

  • meadow_ryan
    meadow_ryan Member
    Answer ✓

    this has been resolved as we actually forced a zero value for our data set

Answers

  • Shevy
    Shevy Contributor
    I have created a date table that I link to to be sure all dates are included. May not be the most elegant - but works and gives you every month!
    Dojo Community Member
    ** Please like responses by clicking on the thumbs up
    ** Please Accept / check the answer that solved your problem / answered your question.
  • meadow_ryan
    meadow_ryan Member

    I don't think that will work for my situation, is there any way that you can adjust something on the card itself?

  • Shevy
    Shevy Contributor
    Unfortunately not today. It needs to exist in the data set to display on a card. So force it in with a date table merge or it will be blank.
    Dojo Community Member
    ** Please like responses by clicking on the thumbs up
    ** Please Accept / check the answer that solved your problem / answered your question.
  • meadow_ryan
    meadow_ryan Member
    Answer ✓

    this has been resolved as we actually forced a zero value for our data set

  • SSFCU_Kristen
    SSFCU_Kristen Member

    I am actually trying to accomplish the same thing here.  I have dates with logged hours that I need to be displayed with zero hours if that is the case.  How would I go about this?  You just build a table and link it...?  I apologize for the seemingly simple question.  I am new to this. 

This discussion has been closed.

Categories