Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to discard zero values in bar chart?

Hi to all,

As you see in screenshot below, I could not discard zero values in bar chart. Is there anybody who knows how to achieve this?

Thank a lot in advance!

screenshot deneme.png

23 Replies
arulsettu
Master III
Master III

in dimension

               disable show zero values

in add-ons

               disable show zero values

Not applicable
Author

Hi Arul,

I have tried your suggestion, but unfortunately it does not work 

Chanty4u
MVP
MVP

here

zer.PNG

Not applicable
Author

As you see, it does not work

Screenshot deneme 2png.png

arulsettu
Master III
Master III

in dimension try this

if(Len(Trim(field)) > 0,field)

Chanty4u
MVP
MVP

try

=if(sum( urfieldname)>0,sum( uefieldname),null())

arulsettu
Master III
Master III

can you post the app

Not applicable
Author

Hi Arul,

Unfortunately I cannot post it, but i took the screenshots of my dimension and expression region. Thanks a lot for your consideration.

My dimension is:

dimension.png

and one of my expression values is like this one: (by the way, i have 8 expression values in total.)

expression.png

arulsettu
Master III
Master III

can you remove the null() from dimension and check it what you getting