Series Label Properties Number formatting
I am developing a column chart in SSRS 2008. But when I select Number formatting for the series label properties and choose zero decimal places, this keeps getting cleared to Default category each time. Below is how I configure these labels:
But after setting this, I reopen the Properties window and it looks like:
So then when I view this chart, the values are appearing as 54.2348945 instead of just 54. How do I fix this so that data labels appear with zero decimal places? These values are calculated from an average calculation, FYI.
Ryan D
November 18th, 2011 10:19am
Hi Ryan,
I don't think so if there is any such issue in BIDS 2008. I tested it here.
For troubleshooting, you can close your BIDS solution and open it again. And then try, the same thing.
Also, you can make use FormatNumber() function.
Right-click the series label.
In Label Data, click Fx
Use the code,
= FormatNumber( Fields!LOS.value , 0)
Regards,
Manoj
*Happy to help
http://experiencingmsbi.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2011 11:35am
Awesome! That fixed it, Manoj. Thanks!Ryan D
November 18th, 2011 12:06pm