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 IIIThe 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. :(