Forum Discussion

AnonymusBIuser's avatar
AnonymusBIuser
New Member
2 years ago
Solved

Data Range Slicer Input Localisation

Hi everyone, I am working on a Power BI report and I encountered an issue with data range slicer input. Currently, the slicer only accepts a period (.) for decimal input instead of a comma (,). This...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AnonymusBIuser 

     

    It's important to note that while DAX and the Power BI interface support localized number formats, certain visual elements like the data range slicer may not fully adhere to these settings due to their specific implementation.

     

    The slicer's behavior of accepting only periods (.) for decimal input, regardless of regional settings, is a known limitation.

     

    You may need to explain this to your users.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AnonymusBIuser 

 

By default, DAX uses commas (,) to separate items in a list and periods (.) to indicate the decimal place in a number. While we do recommend using the defaults, you can use the DAX separators based on your Windows locale settings.

 

You can view the link below for more details:

 

Supported languages and countries/regions for Power BI - Power BI | Microsoft Learn

 

I hope this helps.

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.