Forum Discussion
TheKiltedGolfer
Helper III
Helper IIIMy 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...
parry2k
Super User
Super UserTheKiltedGolfer 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] )
TheKiltedGolferHelper III
Helper IIII 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.