Forum Discussion
Solved
Number Filter visualisation like text filter visualisation
Hi , I have requirement to apply a "Number filter" like we have "Text filter" optoin in power bi desktop to directly pass the number manually. As the client is much familiar with invoice numbers ...
Hi s_nambaru,
You can directly add the numeric field into a slicer, and select a value from slicer to filter visualization.
Regards,
Yuliana Gu
I'm having the same issue. It seems number fields cant be used with the text filters search box.
You could create a new column and cast the number as text and use that,
That's the best solution but to make it work on Direct Query dashboards, in which you're not allowed to use CONVERT,FORMAT or CAST functions, you can use this workaround.
Create a new column like this = CONCATENATE("", [your_int_field]) and bind the Text Filter component to that column.
Hope it'll help