Forum Discussion
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 dont want to show if zero value available in both measures.
Table 1 :
Measurebydays = DATATABLE("Selection";INTEGER ;{{"1"};{"2"};{"7"};{"15"};{"31"}})
Can you just add a RETURN like:
IF(__var = 0, BLANK(),__var)
?
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]
5 Replies
- Greg_DecklerCommunity Champion
Can you just add a RETURN like:
IF(__var = 0, BLANK(),__var)
?
- AnonymousNot applicable
Dear
Thanks for your respond , but its not worked with my scenario :(
- Greg_DecklerCommunity Champion
What if you replace your 0 in your measure with BLANK()?
Going to be difficult to troubleshoot as the things that should normally work don't seem to be, can you share the file?
- v-chuncz-msftCommunity Support
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]