Forum Discussion
Advocate IIICannot Search by Number or Date in Slicer
Why is it that you cannot turn on the search function in a slicer if it is a date or number field? Why does this only work with text?
This is SO frustrating!
20 Replies
ggyczewAdvocate I
Unbelivable 4.5 years
v-frfei-msftCommunity Support
The above link if for a different idea. This is the correct one to vote for:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17308441-slicer-for-number-search
- TabathaN
v-frfei-msft thanks. I just voted for the one linked within the post you recommended
PadycosmosSolution Sage
The work around would be to duplicate the number/date columns, change the data type to "text" and use the search option.
JustSayJoeAdvocate IV
Yes, but you create a new issue by solving the issue this way. Changing these numeric values to text increases the size of the column and adds latency to your load/refresh times.
- NBurnat
yep just thought of this but how ridiculous
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
- TabathaN
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.
- rgouette
Helper II
9/8/2025:
