Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to exclude Zero values in Line chart

Dear Team,   I want exclude Zero values in Line chart , I have two condition filter tables , if these two table satified then i sum the values . Here some days may be values zero will come, but i ...
  • Greg_Deckler's avatar
    7 years ago

    Can you just add a RETURN like:

     

    IF(__var = 0, BLANK(),__var)

     

    ?

  • v-chuncz-msft's avatar
    7 years ago

    Anonymous ,

     

    Just add measure below to visual level filter and set Show items when the value is greater than 0.

     

    Measure 3 =
    [Measure] + [Measure 2]