Hide value in line chart

[svela]

Hi everyone!
Is there a way to include a control that allows to hide/show a value that is a calculated field in a line chart?
So basically what was done here for budget but for a calculated field (filters based on calculated fields do not show the option “filter type”: “filter list”):

Show/Hide values on chart and in legend

I’m trying to figure out how to show/hide a value on a chart. For example below, the user may want to show or hide the budget. I have this working except the Budget value still appears in the legend even though the bars are hidden. Is there any way to do this where it can be taken off of the chart completely when hidden? [image] [image]

[Max]

If it doesn’t show up in the filter list I don’t think it will be possible.

Can you move this calculated field to SQL?

[abacon]

Hi @svela,

Does using a parameter and a control provide a solution as per my example below?

Create a parameter:

Followed by a control for the parameter:

Then use the parameter in your calculated field, e.g.:
ifelse(${pShowdata}="Yes",value/2,NULL)

I then added the measure and a calculated field to a line chart

Changing the control from “Yes” to “No” removes the line for the calculated field

Regards,
Andrew

[svela]

@abacon

ifelse(${pShowdata}=“Yes”,value/2,NULL)

Thank you for your thoughts, Andrew, this is definitely more than half way of the solution but, unfortunately, still missing the option to hide value2 (as in your example) also from the legend when switched off.

[DylanM]

Hello @svela,

If you would still like assistance with this, or if you have a new QuickSight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our QuickSight experts.

I am going to archive this topic since it has been open for an extended period of time. If you were able to find the solution please feel free to post it to help the community. Thank you!