Forum Discussion
maziiw
Advocate I
9 months agoDisplay 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
- Praful_Potphode
Super User
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.
Thanks and Regards,
Praful
- Ashish_Mathur
Super User
Hi,
What is you change the line to continuous?