cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TabathaN
Advocate I
Advocate I

Cannot 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!

ex1.png

ex2.png

ex3.png

9 REPLIES 9
SonamSahoo2020
Frequent Visitor

I am also waiting for this feature.

v-frfei-msft
Community Support
Community Support

Hi @TabathaN ,

 

There is an idea about that, Please vote it up to make this feature comming soon.

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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

@v-frfei-msft thanks. I just voted for the one linked within the post you recommended

Anonymous
Not applicable

@TabathaN  - 

For both dates and numbers, slicers have the option of "Between" slider, which also allows you to type in the boxes.

Slicer Between.PNG

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.

Anonymous
Not applicable

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.

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

 

 

 

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors