How to filter a visual with > or < of the chosen value?

[Anonymous]

Hello all,

currently i have to create a kpi about the Top 1 of product that has the endtime after 12:00H. In the image bellow you can see (red boxes).

How can i filter a product that has the ENDTIME higher  or > 1200 in a object Multi-Row-Card ?

Thank you so much!

[v-shex-msft]

Hi @Anonymous,

You can switch the filter type to advanced filtering and modify the "Show items when the values:" option.

Regards,

Xiaoxin Sheng

[Anonymous]

Hello @v-shex-msft,

Thank you for your response.

I would like to filter all products that are finish from 1200 or later. Which one of the function should i choose?

PS: so for your information this are the availale data that has the endtime from 1200

Thanks.

[v-shex-msft]

Hi @Anonymous,

The first one, the basic filter only filter the value which equal to your chosen.

Regards,

Xiaoxin Sheng

[Anonymous]

Yes i know, but can you give me an example how to filter the product end time between 1200 and 2000?

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Based on your screenshots, it seems like your column not numeric type, you can try change the type to numeric then refer to below screenshot.

Regards,

Xiaoxin Sheng