Post reply

Hide data label for pie chart slices under 10%

  • December 20, 2012 at 2:13 pm

    #393825

    I'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.

  • December 20, 2012 at 3:19 pm

    #1570667

    Change 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), "")

  • December 21, 2012 at 9:16 am

    #1570968

    Sorry for the double post.

  • December 21, 2012 at 9:17 am

    #1570969

    Thanks 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 categoryValue

    1 1 Existing 100000000

    10 10 New 100000001

    13 13 Growth 100000002

    etc, 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).

  • December 27, 2012 at 9:22 am

    #1571912

    bump, any suggestions?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply