Always Show Last 24 Hours on Line Chart When Data Starts with NULLS

[stalerik]

Hello,

I am making a line chart on a continous time-based axis.  I am using the relative time filter to show only the data in the last 24 houts.  When the range starts with NULL values, my x-axis does not go back the full 24 hours.   Instead, it only goes back to the first value and starts the chart from there.  For example, if I have 3 hours of NULL values to start my last 24 houts, then the x-axis only shows the last 21 hours.  How can I make the x-axis always show the full 24 hours even if the daa occasionally starts with NULL values?  I have selected the option to "show items with no data" but that didn't do anything.

Thnaks!

[amitchandak]

@stalerik , You can add +0 to your measure, that will create left join.

[Greg_Deckler]

@stalerik Generally you do that like this:

Measure =
  VAR __Calc = <some calculation>
RETURN
  IF(ISBLANK(__Calc),0,__Calc)

Alternatively:

Measure =
  VAR __Calc = <some calculation>
RETURN
  __Calc + 0

[stalerik]

Thank you for this information.  The new measure converts all the NULLS to zeros and then puts the zeros on the chart.  This does extend the x-axis to the full 24 hours but now it shows zeros on the line chart.  Is there another way to show the full 24 hours on the x-axis but leave the NULL values as missing on the chart and tooltip?  I don't want to give the impression that an actual zero value is in the data, but instead show the values as missing (gap).

[v-lionel-msft · Accepted solution]

Hi @stalerik ,

The tpye of the X axis should be 'Categorical' and enable 'Show items with no data'.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tex628]

I've got a little workaround for this, but it's quite bad since i cant figure out how to fix the tooltip 🙂 

But if you're fine with removing the tooltip and using datalabels instead it should work quite well! 

See the attached file. 

/ J