Line Chat to Continue on zero line when value is blank instead of a single dot.

[MasterT]

Good Day Fam, 

Please assist with below, i am having challenges with below, i want this lines on below to continue to be on zero for that particular month when the is no value/blank. can you assist?

[TheoC · Accepted solution]

Hi @MasterT 

I recommend adjusting you adjust the values by adding a +0 to your measures. Or, alternatively, create a Calculated Column like the following:

Column = IF ( ISBLANK ( 'Table[Column] ) , 0 , Table[Column] )

Just replace the Table name and Column Name you're using in your visual with the above.

All the best.

Theo