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!
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!
SSRS
Last Comment
Nico Bontenbal
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you for confirming!
The Labels of the chart also have a Position property. When I set this to:
![Chart]()
I 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
=iif(Fields!value.Value<10,"Outside","Auto")
I 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
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!