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
The feature has been completed and released in Power BI Desktop May 2020.
More details here:
https://www.sqlbi.com/blog/marco/2020/05/20/standard-dax-separators-in-power-bi-desktop/
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Semicolon as a separator would be best.
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
Pls, it's so important to have the appropiate language not only in words, even in numbres that is so important for the business
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Doing this in Power BI alone sounds like there will be more confusion than before - this would need to go through all products... Scares me - especially if I think about my friends the Excel users. :-)
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Semicolon as a separator would be best.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
For me, the best character separator would be the
semicolon.
It should be available for choice when exporting.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Needed.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
Dearly needed.
RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings
I agree