Forum Discussion
Solved
Remove zero values from graphs
Hello I am trying for 0.00% values not to be shown in the graph. In the visalisation filters I have put Starters - show items greater than zero and same for Leavers. However, that only works if...
if you remove +0 at the end the values will not be shown
I'd use DIVIDE to have division by 0 not showing with errorStarters Rate Level 3 = CALCULATE( DIVIDE( COUNTROWS(Starters), [Headcount Minus Weekly Level 3], -- I assume this is a measure BLANK() -- value for DIV/0 error ) )is there some specific reason why you added 0 at the end of the formula?
if you remove +0 at the end the values will not be shown
I'd use DIVIDE to have division by 0 not showing with error
Starters Rate Level 3 =
CALCULATE(
DIVIDE(
COUNTROWS(Starters),
[Headcount Minus Weekly Level 3], -- I assume this is a measure
BLANK() -- value for DIV/0 error
)
)is there some specific reason why you added 0 at the end of the formula?
Just because I read on a forum that if you didn't want blank to show then add a zero at the end. At this point is was trying to find a a solution for that when using a Card.