Forum Discussion

Farhads's avatar
Farhads
Advocate I
3 months ago
Solved

Issue with Input Slicer and Numeric fields in Power BI Service

Looks like there is a bug in Power BI service only, where numeric fields are treated as text fields and cannot be filtered properly when using the Input Slicer and a numeric field. This only happens ...
General Comment
  • Akad's avatar
    Akad
    2 months ago

    The issue has been resolved I think. It works fine in Power BI Service now

Farhads's avatar
Farhads
Advocate I
3 months ago

hi v-kpoloju-msft 

 

I think these issues are not related (though I could be wrong). The issue I described happens ONLY to numeric columns and there are no issues with Input Slicer responsiveness - it is responsive and works well with the text fields. The issue is it doesn't recognize numeric fields as such. In the example below, I'm taking a numeric column MonthOnBook , you can clearly see it is a numeric column in the standard slicer as it works as a Between slicer. However, the Input slicer is showing all the options related to text fields i.e. Contains Any, Starts with any etc. whilst in Power BI desktop these options do not appear as they are not relevant to numeric columns.

 

 

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
3 months ago

Hi Farhads, 
Thank you for the clarification and screenshots and also thanks to Akad for his response for the above question. 

The MonthOnBook field is correctly recognized as a numeric column in Power BI Desktop and in the standard slicer (Between slicer works as expected). However, after publishing to Power BI Service, the Input Slicer incorrectly treats the numeric field as text and shows text-based operators such as Contains any and Starts with any.

This behaviour is now much more likely to be a Power BI Service-side issue/regression rather than an expected limitation, because the official Microsoft documentation confirms that the Input Slicer supports both text and numeric data columns.
Create and use an input slicer - Power BI | Microsoft Learn

 

Hope this helps. If you have any questions regarding this, please feel free to reach out us. We will be happy to help.





  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    2 months ago

    Hi Farhads, 

    Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

    Thank you.

    • Akad's avatar
      Akad
      Frequent Visitor
      2 months ago

      The issue has been resolved I think. It works fine in Power BI Service now

      • v-kpoloju-msft's avatar
        v-kpoloju-msft
        Community Support
        2 months ago

        Hi Farhads, 

        Thank you for this update. Glad to hear that your issue got resolved. If you have any doubts regarding this please reach out to us. We will be happy to help.

    • Farhads's avatar
      Farhads
      Advocate I
      2 months ago

      hi v-kpoloju-msft Yes, the issue has been resolved now.