Less than, between, and greater than on a text field

[vnicholl]

I have a text field that only has numbers in it - like 1000, 2011, etc.

I want to be able to do the following:

show the first 1000

show from 1000-2000

show 3002, 3003, 3004

Any ideas? I keep trying to find where I can do this in the advanced filter but don't see it. It only allows me to choose values in the basic. 

[vnicholl]

Great idea! However the documentation I read said that this wouldn't change anything after 1000 and my #'s start in the 3K's, and do skip around some. Thanks though!

[amitchandak · Accepted solution]

@vnicholl , if only have numbers then you can convert data type whole number.

You can use what if a parameter to create between filter

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

[vnicholl]

I will give this as a try. Thank you!