Text in chart - getting it to disappear when clicking chart

[#1]

Hi all,

I have put text in a bar chart at the end of the bars (its horizontal), but the problem is when I click on a bar, all the stays in place and ruins the look of the chart. I am just wondering if there is a way to get rid of the text in chart when I click on a bar, but bring it back when I clear my selections?

[datanibbler · Accepted solution]

Hi,

sure. Your chart follows some dimension surely. That is a field you can refer to. So in the edit_field for your text, just insert an IF_construct with the GetselectedCount() function to identify whether that field has been selected on - which is the case when the bar has been clicked on.

=> Sth like >> IF(Getselectedcount([dimension_field]) >= 1,' ', '[text]') <<

=> That way, when one of the bar in your chart has been clicked, that text would be empty. (don't forget to put a transparent background to your text)

HTH

Best regards,

DataNibbler