• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

How to remove the Lable of stack bar when the data is 0

I created a stack bar showing the No. of staff  from 3 differnet Country.(CountryA, Country B,Country C)
I used the data lable with the stack bar for each country.
My issue is: In case {NO. of Stuff (Country B)}=0, then the Data label shows 0.
But How can I remove the lable  whenver the value is 0. while keep the other data lable which is not valued 0.
Thanks

Grace

0
FinghtingMiao
Asked:
FinghtingMiao
1 Solution
 
shorakCommented:
No sure if this will work but if you goto the properties of your chart and select the point Labels tab, In the data Label box, you could put an expression like:

=iif(Fields!No_of_stuff.Value=0,"",Fields!No_of_stuff.Value)

As I have said, it might not work but give it a try.

Rob
0
 
FinghtingMiaoAuthor Commented:
Thanks u.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now