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
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
Thanks alot Khilit it work for me.
Thanks Khilit, Saved me some sleep.
I used it in a bar graph.. The irony is the regular expressions worked fine for two of them and when I apply the same for the third the numbers were distorting..
Thanks again.
Superb…Thanks You saved lots of my time
It was a great instruction. In my case I want to change the horizontal axis date label to Quarters. Is it possible?
Worked like a charm. Thanks alot