Forum Discussion
Cannot Search by Number or Date in Slicer
TabathaN -
For both dates and numbers, slicers have the option of "Between" slider, which also allows you to type in the boxes.
Hope this helps,
Nathan
That option is tedious and I believe has a small bug in it. If you do a between search once, then go back to enter a value in the first box and tab to the second, it reverts the first box back to the last search and you have to go back and type in the second search, in the first box, again.
I don't want to have to type out a number twice when I'm searching for a single value. Also, if I want to find all values that contain a string of "123", you can't, it has to match exactly.
One options is to add a text version of your column for a slicer. Or change the column data type. Typically, descriptive attributes are text types.
an issue with this:
if you have mostly 7 digit numbers in a Text field, but some numbers are only 4 digits, the search function is unable to return the smaller numbers- e.g. searching "4147" returns a list of 7 digit numbers that END with 4147. The number that was searched for does not even appear at the end of the list.
Not preferred, but could be somewhat resolved by duplicating the column and adding a space, whereafter you could type 4147 +spacebar to search for only this value.
Anonymous until Microsoft can "fix" this, your suggestion of duplicating the column and changing the data type of my case number works. Thank you so much for this suggestion!
Hallo,
two year passed and no fix!
Thanks for nothing.
