Turning off Point Labels in Report

I am in the process of creating a report and one of the graphs is a pie chart. Most of the totals are small, but there are a few that need highlighting. I can get the point labels to show as I like, but I cannot turn them off for the small values. Is this possible, and if so how.

Here is the code that I currently have for the Point Labels....

=IIF(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events") > 0.05, FormatPercent(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events"), 1) & "," & Fields!Cause_Code.Value, "")

That works and formats it properly, except the false puts in the series label. Attached is a the graph as it currently stands.

Thanks

Chris
graph.jpg
LVL 1
TWCMSNAsked:
Who is Participating?
 
catherinelouiseConnect With a Mentor Commented:
Hello Chris!

I'm not an Expert, but had a play around and recreated your problem, and found that by putting at least one space between the double quotes prevented the label from being displayed.

So try this instead

=IIF(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events") > 0.05, FormatPercent(Count(Fields!OUTAGE_ID__.Value)/Count(Fields!OUTAGE_ID__.Value, "Availability_vwReport_Events"), 1) & "," & Fields!Cause_Code.Value, " ")

Regards, Catherine
0
 
TWCMSNAuthor Commented:
This works for having the labels blank, but this still leaves the lines. If those can be disabled, the problem is solved. I'll see what I can do, and if someone has any additional informatoin, that would be great.

Thanks,

Chris
0
 
catherinelouiseCommented:
Hey,thanks for accepting my solution - I guess you didn't have much choice though eh ;-)

I just wanted to say that I looked and looked and found other people with the same problem, there just doesn't seem to be an answer for it.  The only additional point I have is that if you don't position the label yourself and use auto-label, then the text generally appears without the line and then this solution works OK.  I guess that all depends on the amount of data on your pie-chart as to whether that really is a suitable solution or not.
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.

All Courses

From novice to tech pro — start learning today.