Filter data based on one control only

Hi @katep,

I think the best way to do this is by using a parameter.

First create a string parameter. In my example, it’s called Dimension. Choose a default filter and use it as the static default value of your parameter.

Use your parameter to add a dropdown control and define specific values for the fields that you want to filter by.

Create a calculated field like this:

Create a filter for your calculated field and add a control for it. You can use your parameter as the title of this control.

You should now have 2 controls. Use the first one to select the field that you want to filter by and use the second one to select the field value.

1 Like