Number Filter visualisation like text filter visualisation

[s_nambaru]

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.

[Niekert7]

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.

[krisiana]

Hi,

i have used this solution and it's work for my dashboard 🙂

[v-yulgu-msft · Accepted solution]

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

[kalyan209]

Hi,

Can we add a search bar for this slicer with numeric values??

Thanks

[dazlari]

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.

[EngraciaBatista]

Yeah, I have the same feeling.

None of the options I saw so far solve my issue.

[s_nambaru]

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

[StephenF]

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,

[Anonymous]

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