none
How to Insert text in Bar Graph, Series Label Properties in Report Builder 3.0

Answers

  • Hi Kitty,

    If I understand correctly, you want hide the Label name if it is have no value.

    We can change the expression of Label data to get the result.
    You can refer to the expression below:
    =IIF(Count(Fields!PLANNER.Value)>0,"#LEGENDTEXT",Nothing)

    You can refer to the screenshot below:

    Hope this helps. If there are any misunderstanding, please feel free to let me know.

    Regards,
    Alisa Tang

    • Marked as answer by KittyCat101 Wednesday, September 11, 2013 9:00 PM
    Wednesday, September 11, 2013 3:28 AM

All replies

  • I need the names in the bar graph to be exact.  I used Series Label Properties, General, #LEGENDTEXT to get the names onto the bar graph.  The only problem as you can see is that it wants to list all the names in each individual bar even if they don't have a value.  How can I fix this?

    Below is the original settings for the Chart Data: 


    • Edited by KittyCat101 Monday, September 09, 2013 9:16 PM
    Monday, September 09, 2013 9:12 PM
  • Hi Kitty,

    If I understand correctly, you want hide the Label name if it is have no value.

    We can change the expression of Label data to get the result.
    You can refer to the expression below:
    =IIF(Count(Fields!PLANNER.Value)>0,"#LEGENDTEXT",Nothing)

    You can refer to the screenshot below:

    Hope this helps. If there are any misunderstanding, please feel free to let me know.

    Regards,
    Alisa Tang

    • Marked as answer by KittyCat101 Wednesday, September 11, 2013 9:00 PM
    Wednesday, September 11, 2013 3:28 AM