Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Remove 0 values in line chart

Hi All,

 

I am trying to remove values coming through as blank as there isn't future data for one of the measure (which is correct) but when I remove these using filters on the visual it shortens the time horizon, is there any way around this?

 

Below are screenshots of what is happening.

 

 

 

 

 

  • @markb141 , the Y axis is not visible, so it is not able to check what it is saying. If you do not want to remove the value from the x-axis who you want it to display. An alternate is

    measure 1 - if([Measure]-0, blank(),[Measure])

    This will cause 0 values as blank, try to

2 Replies

  • @markb141 , the Y axis is not visible, so it is not able to check what it is saying. If you do not want to remove the value from the x-axis who you want it to display. An alternate is

    measure 1 - if([Measure]-0, blank(),[Measure])

    This will cause 0 values as blank, try to

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Amintchandak,

       

      Thanks your recommendation has worked.