Forum Discussion
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
- amitchandakSuper User
@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
- AnonymousNot applicable
Hi Amintchandak,
Thanks your recommendation has worked.