Filter Pane

[JoseGarcia]

Hi there, 

how do I make  filter pane show only two  values from the dimension? using formula: 

=if(Dimension = 'Value1' or Dimension = 'Value2', Dimension)

This is not working 😞
Any ideas?
Thanks! 

[Vegar · Accepted solution]

Your expression looks OK.

Try

If(match(Dimension,'Value1','Value2'), Dimension,  null())

Or try 

Aggr(Only({<Dimension={'Value1','Value2'}>}Dimension),Dimension)

[JoseGarcia]

Hi Vegar, both expressions worked nicely! 

Thansk a million for your support here!