Filtering Colums in Diagramm

[Anonymous]

Hello Together,

I have the following Visualization:

As you can see there are three value columns used in the Diagramm. I know want to make a filter that enables me to select which colum I want to visualize (one of the colums, two, or alle three). The filter is supposed to be used in the Dashboard and connected to other filters, thats why I cannot just select the columns in the fields menu.

Has someone an idea?

Thank you very much

[Anonymous]

Thank you for your answer. Field parameters would be the perfect solution but I can only get them to work for the x axis. But in my case I would need them to work for the y axis, It just looks like this:

If i use it as x axis it works but then of course the data makes no sense. Is there a solution for this?

[AlexisOlson]

You can either unpivot your data or use the new fields parameter feature.

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

https://www.sqlbi.com/articles/fields-parameters-in-power-bi/