Unwanted selections in filter pane

[JoeWhite]

Greetings.

I created a filter pane with calculated dimension like so:

if(vVariable=1,[Field 1],[Field 2])

So when vVariable=1 it shows me Field 1 values in filter, but when I make selection it also makes selections in Field 2.

If I use separate filters for Field 1 and Field 2 it doesn't happen and only makes selections in one field at a time.

I am forced to use variable because I have limited space.

Is there a way to avoid this problem?

Thanks.

[GaryGiles · Accepted solution]

Use $-expansion to cause the expression to be evaluated prior to being rendered in the Filter Pane, like this:

=$(=if(vVariable=1,'[Field 1]','[Field 2]')

It will still respond if the value of vVariable is changed.

[JoeWhite]

Thank you, it is working now!