SSRS Chart – Displaying % sign on Y axis + Displaying % sign on Data Labels
Hi guys,
Today i would like to show you the little trick for your SSRS graphs.
Issue:
I am displaying values (percentage values) in my bar charts as “Data Labels”. But the “Y” axis of my bar char still displays value without the “%” sign.
What I need:
The bar chart should display the “%” value in Data Labels as well as on my Y axis.
Simple try:
When you format the Data Label to apply “%” sign by making it of type “Percentage” in “Series Label Properties” -> “Number” -> “Percentage”. It actually multiply the value by 100 and put a % sign at the end. Woh … but the value i am displaying on my Data Labels are already percentage. I just need to display the % sign at the end.
Solution:
Let’s trick the SSRS to display that % sign on you Data Labels as well as on your Y axis.
1. Go to your Series and enable “Data Labels”
2. Right click on Data Label -> Series Label Properties -> Number -> Currency -> select 2 check-boxes : “Show symbol after value” and “Include a space”
3. Then without closing this dialog-box, click on Custom. Place % sign in place of $ sign 
Then click Ok.
4. View your chart. Now apply the same for Y axis.
I hope this will help you somewhere.
Thanks, khilit
August 4, 2012
· 
Khilitchandra Prajapati · 
6 Comments
Tags: Business Intelligence, Charts, Data Label, SQL Server, SSRS, Tricks · Posted in: Business Intelligence, Quick Fix, Quick Tips, SQL Server, SQL Server 2012, SSRS, Suggestion, Tutorial
6 Responses
It was very usefull. Saved my day .Thanks.
Khilit, once again your blog has saved the day. When I changed my chart to percentage it was displaying everything as 100,000%. So I am using this method instead.
You are welcome
Thanks, Khilit
That’s great and hard to notice.
Thanks
Thanks Mate,
worked for me on Vertical Axis as well. Without going to data series labels
Welcome
Khilit
Leave a Reply