Forum Discussion

s_nambaru's avatar
s_nambaru
Frequent Visitor
8 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
    8 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
Icon for Microsoft Employee rankMicrosoft Employee
8 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

  • kalyan209's avatar
    kalyan209
    Frequent Visitor
    7 years ago

    Hi,

     

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

     

    Thanks

    • dazlari's avatar
      dazlari
      Regular Visitor
      6 years ago

      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's avatar
        EngraciaBatista
        New Member
        4 years ago

        Yeah, I have the same feeling.

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

  • s_nambaru's avatar
    s_nambaru
    Frequent Visitor
    8 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
      Icon for Responsive Resident rankResponsive 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