Forum Discussion

maziiw's avatar
maziiw
Icon for Advocate I rankAdvocate I
9 months ago
Solved

Display null values as blanks in a line graph

I have a line graph where I select one observation from a list and the graph displays a metric for that selection across days.

Sometimes metrics are Infinity. I want to display it in a line graph as spaces, so the line breaks. But all that happens is hiding the days when it is blank. How can I fix it?

The measure I use is:

Odds (Filtered) = 
VAR Value = SELECTEDVALUE(source_all[ODDS])
RETURN
IF(
    Value > 1E+308,   // Treat extremely large values as infinity
    BLANK(),
    Value 
)

 

and the view I want to change is this:

 

  • Hi maziiw 

    That is not possible with continuous x-axis. Change it to categorical and under the field options, select show items with no data.

     

3 Replies

  • Hi maziiw ,

    Instead of Date Column ,create a text column which has date and sort it as per date.

    then blanks of text columns will shown in your line chart.

     

    Sample PBIX

     

    Thanks and Regards,

    Praful

  • Hi maziiw 

    That is not possible with continuous x-axis. Change it to categorical and under the field options, select show items with no data.