Forum Discussion
Data Range Slicer Input Localisation
- Anonymous2 years ago
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.
Hi Nono Chen,
Thank you for your response. I understand that by default, DAX uses commas (,) to separate items in a list and periods (.) to indicate the decimal place, and that these can be adjusted based on Windows locale settings.
However, even though all my language settings are set to German and the DAX separator is set to regional settings, the data range slicer still only accepts periods (.) for decimal input. This is causing confusion for my users, who are accustomed to using a comma (,) as the decimal separator in Germany.
Is there any other configuration or workaround that might address this issue specifically for the data range slicer? Any additional help would be greatly appreciated.
Thank you!
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.