Forum Discussion
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 he is dealing with.
The storage Mode for
Can anyone help me on this.
Thanks in Advance.
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
9 Replies
What worked wonders for me is to simple duplicate the column of data set to numbers you want to filter on. Set the duplicate to text and use the textfilter on that column.
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
Hi,
Can we add a search bar for this slicer with numeric values??
Thanks
This is not solved!
I'm looking for the same outcome as the original poster. The ability to enter a number into a field for filter selection without the use of the slider (min/max). A long list of numbers swamps the slicer's page memory.
There is a Filterlist by DevScope in the Marketplace which will solve this, but no where near as elegant as the MS slicer.
Thank you for the reply.
The slicer you have suggested is that ,we can either use list /dropdown/between options in the slicer where we cannot enter the single number manually into the slicer.
As i mentioned before ,my user is familiar with the invoice numbers which he is dealing with.So he is expecting a slicer which the invoice number can be manually be entered and get data out of it.
Thanks in Advance...
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,
Hi,
i have used this solution and it's work for my dashboard 🙂
