Forum Discussion
Input Slicer
Input Slicer is working with text field and not working with numeric fields. Is it by design?
thank you
3 Replies
- Kannan_n
Advocate III
Hello klimkiv
Yes, this is currently by design.
The new Input Slicer visual in Power BI Desktop / PBIRS is built primarily as a text-matching search filter (supporting string operators like Contains, Starts with, Is, etc.).
Direct numeric column types (such as whole numbers, decimals, or currency) are not supported out of the box for free-text typing in the Input Slicer.
If you need free-text search on numeric values (such as typing an exact ID, postal code, or account number), create a calculated column or convert the field data type to Text in Power Query.
If you need mathematical range filtering (e.g., between, greater than, or less than), use the standard Slicer visual set to the Between or Numeric Range slider style rather than the Input Slicer.
Thanks
Kannan N
- Murtaza_Ghafoor
Super User
Hi klimkiv,
Hope you are fine and doing great.
In case of numeric field the behavior is different and you need to filter the data for some specific range and it should work.AS an example please refer to below screen shot from Microsoft docs.Docs Link:
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-input-slicer
If this helps, ✓ Mark as Kudos | Help Other
- klimkivFrequent Visitor
Input Slicer is working with numeric fields in desktop and not working in PBIRS, is it a bug?