InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:43:12 GMT20http://www.sqlservercentral.com/Forums/Topic1399105-150-1.aspxbump, any suggestions?Thu, 27 Dec 2012 09:22:12 GMTjchickyhttp://www.sqlservercentral.com/Forums/Topic1399105-150-1.aspxThanks for your help. I'm not sure exactly how to explain the problem I'm having...UseValueAsLabel was already False. In the label property, I had #PERCENT{P0}, otherwise the labels would show the count for that particular category.My DataSet1 has a query that groups 6 categories and counts each row in a column. For example:total totalValue category categoryValue1 1 Existing 10000000010 10 New 10000000113 13 Growth 100000002etc, etc.In the chart data, I have [total] in the Values area (no aggregate function used), and category in the Category Groups area. Everything previews great.. I just don't want to show slices under 10% because the chart is quite small and so the labels overlap when they're under 10%. When I try your expression, I get #Error (rsAggregateOfNonNumericData) for the labels (I put your expression in the label property).Fri, 21 Dec 2012 09:17:08 GMTjchickyhttp://www.sqlservercentral.com/Forums/Topic1399105-150-1.aspxSorry for the double post.Fri, 21 Dec 2012 09:16:29 GMTjchickyhttp://www.sqlservercentral.com/Forums/Topic1399105-150-1.aspxChange the UseValueAsLabel to false.Here's an example of an expression I just wrote to test this out.If Revenue for Department / TotalRevenue > .1, then show Department revenue, else "" Blank=iif(Sum(Fields!Revenue.Value) / Sum(Fields!Revenue.Value, "DataSet1") > .1, Sum(Fields!Revenue.Value), "")Thu, 20 Dec 2012 15:19:35 GMTRay Mhttp://www.sqlservercentral.com/Forums/Topic1399105-150-1.aspxI'm working on a pretty simple pie chart in BIDS 08. I have 6 slices of pie and want to hide the data label for slices less than 10%. I assume this is an expression that gets entered into the Chart Series Labels' 'visible' property, but I don't know where to start.If you all can help me out, I would greatly appreciate it. Part of what has me confused is that the expression will probably be written assuming the values of my data are percentages, but they're integers (aggregated counts). I believe this transformation from integers to percentages happens in the background and I wouldn't know how to write an expression for that.Thu, 20 Dec 2012 14:13:55 GMTjchicky