Show and Hide data point from line and stacked column chart

[Anonymous]

Hi All,

I have a Line and Stacked column chart and a Chart Option slicer. How do I show and hide the data points (bar and line data points) by toggling the slicer? This Chart Option slicer has no connection to any data tables.

E.g., if deselect A from slicer, data point A should not appear in the chart.

Thanks.

Regards,

BK

[mwegener · Accepted solution]

Hi @Anonymous ,

with a measure you can check the selection and output or hide the value accordingly.
Here is an example:

A = IF("A" in VALUES('Chart Option'[Chart Option]), SUM('Table'[A]), BLANK())