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 each department has starters and leavers with a value greater than zero. So for Asset Mgt it wouldn't show anything even though leavers is 2.54%.

 

Is there any way round this?

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?

5 Replies

  • 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?