Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
7 years ago
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...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    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?

Stachu's avatar
Stachu
Community Champion
7 years ago

what's the syntax for your % measure?
normally if you use DIVIDE blanks should not be shown

otherwise you can create a separate masure that would be just used for the filter 

  • rosscortb's avatar
    rosscortb
    Post Patron
    7 years ago

    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
    • Stachu's avatar
      Stachu
      Community Champion
      7 years ago

      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?

      • rosscortb's avatar
        rosscortb
        Post Patron
        7 years ago

        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.