I have multiple controls to filter my data but I only want the user to be able to filter by one control at a time. eg I have one control that filters the data by state and another that filters by hospital type. I don’t want the user to be able to filter by both at the same time. eg If they select a state then I want the other filter to default to All hospital types and vice versa.
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.
Hi @David_Wong thank you so much for the clear instructions. I have managed to get this working which is great. I am just having one minor issue. Once I select a Customer and then go to Filter by something else like Product then the Product control list includes all products plus it still includes the previously selected Customer until I click ‘Select all’. Any ideas how I can have it automatically default back to ‘Select all’ when I click the next field to filter by?
Hi @katep,
It’s a known issue when using cascading controls like that. I don’t think there’s a solution for that yet. You have to manually reset the filter to clear the previous selection.
Thanks for clarifying.