Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

Data lables on Chart

I added data labels to my chart but it appears that it is showing labels per every category including the categories that i don't have anything for (ie they appear a zero) ... any way to hide the ones with zero?
0
vbnetcoder
Asked:
vbnetcoder
  • 3
  • 2
1 Solution
 
SimonCommented:
Depending on your query type, add a WHERE or HAVING clause to omit the empty categories.
0
 
vbnetcoderAuthor Commented:
Actually, this is what i needed to do:

=IIf(count(fields!Status.Value) = 0, false, true)
0
 
SimonCommented:
Does your last comment mean you've resolved the problem successfully?
0
 
vbnetcoderAuthor Commented:
yes
0
 
vbnetcoderAuthor Commented:
ty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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