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?
Hi
Thanks for replying
I am using this measure -
Starters Rate Level 3 = CALCULATE(Countrows(Starters)/'DB Headcount'[Headcount Minus Weekly Level 3])+0
Ross
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?