I have a line chart with two series. I would like to show or hide each series based on whether they are checked in a report parameter.
For example, if Ongoing is unchecked in the list below, the red line should disappear from the chart and legend. Is this possible?
If so, what property on the graph should be toggled and how can a particular checkbox value be determined in an expression?
For testing purposes I have hard-coded the data in the data source like this:
SELECT '2021-1' YearMonth, 1 AS New, 2 AS Ongoing UNION ALL SELECT '2021-2' YearMonth, 2 AS New, 3 AS Ongoing UNION ALL SELECT '2021-3' YearMonth, 4 AS New, 1 AS Ongoing