How to select specific values?

[ysapiyev]

Hi everyone,

I have a visual with rectangles and values inside of these rectangles. Is it possible to have a slicer, which will highlight values >0?

For example, I have 4 values - -2, 0, 5 and -3. So, using this slicer, only rectangles with -2 and -3 would be highlighted.

[Greg_Deckler]

Use the little drop-down arrow on your slicer (next to the little eraser icon), it is right below the ellipses. You can change the slicer to less than or equal to and greater than or equal to.

[ysapiyev]

@Greg_Deckler,

Thanks for your answer. I forgot ro mention it, I need to highlight data, not filter it. So far I was able to filter it using your suggestion. also, is it possible to use 2 conditions in one slicer? for example value1>0 and value2<0?

[Greg_Deckler]

Hmm, not sure about the highlight part. Use Between in the slicer setting.

[ysapiyev]

@Greg_Deckler,

betwen in settings will have condition for one value. is it possible to have conditions for two different valuesin one slicer? logically it would be IF(value1<0 && value2>0)

[Greg_Deckler · Accepted solution]

Nope. Use 2 slicers.

[ysapiyev]

ok, thanks.