Toggle visibilty of Column Chart series

  • I'd like to give my end users a way to toggle the visibilty Series label in a column chart. I see where I can set Series Label Properties Visibilty according to an expression, but there's no option to set a toggle control. Can I do it through an expression and a text box? I didn't think there was a way to detect a click event.

  • I'm pretty confident in saying that no, you can't do this in the report itself. In that, you can't have an clickable item that makes it switch "on" and "off". What you could do, however, is add a parameter to your report of a Boolean type. This will appear as a tick box to the user in the report parameter pane. If they want the label(s) not displayed all they have to tick the box and rerun the report.

    To set this up, you'll need to create said parameter (I'll call it HideLabel). Then, on each of your labels on your charts you want to be able to toggle you'll need to go to the Visibility property and set it to hide/display using an expression. The expression you need is:
    =Parameters!HideLabel.Value
    This will tie the visibility to the tick box (True being Hide, and False being Display).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Ah, I see. Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

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