Forum Discussion
Show on a lineplot months without data does not work?
I have a lineplot which shows a value per month for 3 brands. In august no brand has any value, but I want to show this gap.
I have used "Show items with no data" option for a column from my Date Table but it did not help, the plot continues without showing August.
What can be a solution?
Good nigth Anonymous, the best way to do this is fix your measure to show "zero" when the value is blank.
Try this:
Measure =
var Value = Table[Value]
var Validation = if(Value>0,Value,0)
return Validationwith this, if the value is blank, the measure will show zero.
2 Replies
Good nigth Anonymous, the best way to do this is fix your measure to show "zero" when the value is blank.
Try this:
Measure =
var Value = Table[Value]
var Validation = if(Value>0,Value,0)
return Validationwith this, if the value is blank, the measure will show zero.
Thanks DanielGarcia. I was looking for another solution because in this way I can not see the gaps and the lines show continuing trend.
But seems that this is the only solution up to now.