Forum Discussion

TheKiltedGolfer's avatar
TheKiltedGolfer
Icon for Helper III rankHelper III
7 years ago

My line graph will not show blank data for dates

My simple line graph is not showing all of the data that I want. I need the X axis to show 24 scrolling months of dates where the most recent scrolling 12 months will always have data but the first s...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

TheKiltedGolfer change the measure for your line graph to return 0 instead of blank.

 

assuming your line meause is called "measure" you can do something like this, it will force to show value for 0 and you will see the line.

 

measure = if (ISBLANK[Measure], 0, [Measure] )
  • TheKiltedGolfer's avatar
    TheKiltedGolfer
    Icon for Helper III rankHelper III
    7 years ago

    I really do not want it to show "0" on the line graph because that really is not the value. It needs to be blank and just have a data line starting 12 months ago to the present day.  Showing a "0" means something different to me than a blank for a date.

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      TheKiltedGolfer well in case you don't want to show "zero" i don't think line is going to get plotted for blank value. I don't see any solution here.

  • TheKiltedGolfer's avatar
    TheKiltedGolfer
    Icon for Helper III rankHelper III
    7 years ago

    The strange thing is that when I was pulling in the data from Excel the graph would work. But we are not pulling straight from SQL database and it is not working.  :(