Filter metrics presented in different columns

Create a Parameter Table:
Start by creating a parameter table that contains a list of metric names. You can create a simple table with one column for Metric Name.

MetricName
-----------
Metric1
Metric2
Metric3
... (add more metrics)

Create a Slicer:
Add a slicer to your report based on the Metric Name column from the parameter table. This slicer will be used by users to select the metric they want to display.

Create a Measure:
Now, you need to create a measure that dynamically selects the chosen metric based on the user's selection. You can use the SWITCH function for this purpose.

SelectedMetric =
VAR SelectedMetricName = SELECTEDVALUE('ParameterTable'[MetricName])
RETURN
SWITCH (
SelectedMetricName,
"Metric1", [Metric1],
"Metric2", [Metric2],
"Metric3", [Metric3],
... (add more metrics)
)
Replace [Metric1], [Metric2], [Metric3], etc., with the actual column names that correspond to your metrics.

Create Visuals:
Now, you can use the SelectedMetric measure in your charts or visuals. When users select a metric from the slicer, the measure will dynamically switch to the corresponding metric column.

For example, if you create a card visual to display the selected metric, you would use the SelectedMetric measure in the Values field of the visual.