bigator

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

bigatorAugust 4, 2012 · bigatorKhilitchandra Prajapati · bigator11 Comments
bigatorTags: , , , , ,  · Posted in: Business Intelligence, Quick Fix, Quick Tips, SQL Server, SQL Server 2012, SSRS, Suggestion, Tutorial

11 Responses

  1. Mahadev HK - November 8, 2012

    It was very usefull. Saved my day .Thanks.

  2. Ken - January 9, 2013

    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.

  3. Khilitchandra Prajapati - January 10, 2013

    You are welcome 🙂
    Thanks, Khilit

  4. Biz - April 13, 2013

    That’s great and hard to notice.
    Thanks

  5. Hammad - May 13, 2013

    Thanks Mate,

    worked for me on Vertical Axis as well. Without going to data series labels

  6. Khilitchandra Prajapati - May 13, 2013

    Welcome 🙂 Khilit

  7. abhijeet - September 23, 2013

    Thanks alot Khilit it work for me.

  8. Prawin - August 4, 2014

    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.

  9. Vijji - August 29, 2014

    Superb…Thanks You saved lots of my time

  10. Suresh - September 1, 2014

    It was a great instruction. In my case I want to change the horizontal axis date label to Quarters. Is it possible?

  11. Anil - October 21, 2014

    Worked like a charm. Thanks alot

Leave a Reply


%d bloggers like this:
bigator