topic Re: How to select specific values? in Developer

How to select specific values?

ysapiyev — Tue, 30 Jan 2018 14:00:10 GMT

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.

Re: How to select specific values?

Greg_Deckler — Tue, 30 Jan 2018 16:44:31 GMT

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.

Re: How to select specific values?

ysapiyev — Tue, 30 Jan 2018 16:48:24 GMT

@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?

Re: How to select specific values?

Greg_Deckler — Tue, 30 Jan 2018 16:52:09 GMT

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

Re: How to select specific values?

ysapiyev — Tue, 30 Jan 2018 16:55:16 GMT

@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)

Re: How to select specific values?

Greg_Deckler — Tue, 30 Jan 2018 16:59:12 GMT

Nope. Use 2 slicers.

Re: How to select specific values?

ysapiyev — Tue, 30 Jan 2018 16:59:58 GMT

ok, thanks.