Power BI
CompletedOption to use comma as list separator and dot as a decimal point regardless of locale settings
Marco Russo on 21 Oct 2019 16:17:33
Power BI Desktop has an editor that modifies the DAX code trying to respect the locale settings. This creates a number of issues in certain combinations of locale settings; because of that, there are bugs that have never been fixed when you have certain expressions
Moreover, respecting the syntax using locale settings creates additional issues when you copy/paste formulas in other tools that might not use the locale settings (not to mention community forums!).
Please, consider adding an option to Power BI Desktop to use the standard comma (,) as list separator and dot (.) as decimal point for DAX editor in Power BI. This way, you will make life easier to many developers managing different locale settings in their environment. As an added bonus, you (MS devs) will have more time to fix the existing bugs, because you (MS support) will be able to provide a better workaround (today users have to change Windows settings).
Administrator on 20 May 2020 23:31:30
I'm excited to say that this item is completed! Marco Russo joined the PBI team through the Contributor program and was able to implement this for the May 2020 release. Thanks, Marco! https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_List_separator
- Comments (20)
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
That would be great!
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
It enhance the product.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
This would be amazing - I didn't even know this was a problem until I moved country. This would make things so much easier for people working across various locales.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
We need this in Germany - working on a EN Lang installed database and a regional DE Excel!
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
yes yes yes... This is so needed.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Goodidea
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Specialy for the mobile app
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Good idea
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Would be highly appreciated here in Norway.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Yes, I agree.