Display and hide lines for line chart

[TestingForTestPurposes]

Hi all,

I calculated the forecast of the available budget for four products. For every product I have a single table with the columns Volume and date. By adding the date as the date a the dimension for the line chart and adding the sum of the budget for the four individual products as measures I was able to achieve a line chart with four lines as expected.

No I want to add the functionality to display and hide the individual lines. Therefore I created a new table with inline load containing the four names of the products.

For the measures I have the following function = IF(product='a',Sum(volume_a))

This works if I select one single product but I am not able to select several lines to be displayed in the chart.
What do I have to change to display several lines at once?

[Chanty4u]

Try this

Create a variable

vSelectedProducts. Set its initial value to an empty string

=IF(Match(product, $(vSelectedProducts)), Sum(volume))

[TestingForTestPurposes]

It seams not to work.

The $ seams to be not allowed in this function as I receive the error that at least 2 parameters are required for the match and without the $ nothing is displayed.

Is there an other option to do this or did I do something wrong?