Forum Discussion
Line Chat to Continue on zero line when value is blank instead of a single dot.
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?
Hi Anonymous
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
1 Reply
- TheoC
Community Champion
Hi Anonymous
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