LinkedIn
Twitter
Hello,
As a BI dev, I developed a dashboard where I have set several filters and I would like to force the end user to select AT LEAST one option from two filters that I would set to "required filter value". This is for lowering the cost of the queries since the source tables are more than 22 gb.
The Issue I am facing is that, if I set the two filters as a value required, may be one of the two filters is going to have null values so I could not select any option for that filter
i.e. you can see I have selected one option from the second filter, but this selection makes no match values in the other filter so I can't select any option from that filter.
The output or what I'd like to achieve is to be able to select one option from one filter OR the other filter. So in that case, whenever I choose one option from one filter, the other one doesn't require a value. Basically, what I need is:
Required value [filter 1] OR required value [filter 2]
Right now is:
Required value [filter 1] AND required value [filter 2]
How can I set this logic in the filters?
