Link to home
Create AccountLog in
Avatar of KANEDA 0149
KANEDA 0149Flag for United States of America

asked on

SSRS Pie Chart Data Points Inside AND Outside

I'm using SQL Server Data Tools for Visual Studio 2013 to create SSRS reports.  One of the report is a Pie Chart which I want the Data Points to be displayed both Inside and Outside the pie.  Is that even possible?

Under the Pie properties » CustomAttributes » PieLabelStyle you can only select "Inside" or "Outside".  I see an <Expression...> option but I'm not sure how this used to accomplish have the data point labels both inside and outside the pie chart.

Any recommendation or assistance on this would be great!
ASKER CERTIFIED SOLUTION
Avatar of Arifhusen Ansari
Arifhusen Ansari
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of KANEDA 0149

ASKER

Thank you Arifhusen for the confirmation.  I wasn't sure if was possible in SSRS, I kinda figured but I thought I'd ask.  

The reason why I would like it inside & outside was the ability to show the data labels smaller than the pie slice outside so the report viewer can view the values without having to include a data table.  It was more visually appealing.  In the screen shot below you'll see the effect with some data points outside and some on the inside, looks clean.

As a workaround in SSRS, all I did was make the data points invisible if the values were less than 10 and included it in the Legend.  Best solution for me.  Thanks again for your response!

User generated image
Thank you for confirming!
The Labels of the chart also have a Position property. When I set this to:
=iif(Fields!value.Value<10,"Outside","Auto")

Open in new window

I get the effect you are looking for (kind of).
 User generated imageI tried to find a property to control the distance of the label from the chart, but I couldn't find it.
I've attached the sample report.

You also might find some interesting information in these articles:
https://msdn.microsoft.com/en-us/library/dd220583(v=sql.120).aspx
https://betterdashboards.wordpress.com/2009/01/20/overlapping-labels-on-a-pie-chart/
PieLabels.rdl