Forum Discussion

s_nambaru's avatar
s_nambaru
Frequent Visitor
7 years ago
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 ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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

s_nambaru's avatar
s_nambaru
Frequent Visitor
7 years ago

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's avatar
    StephenF
    Responsive Resident
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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