Skip to main content

Power BI

Completed

Option to use comma as list separator and dot as a decimal point regardless of locale settings

Vote (370) Share
Marco Russo's profile image

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)
Marco Russo's profile image Profile Picture

Marco Russo on 06 Jul 2020 00:13:48

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/

Marco Russo's profile image Profile Picture

luismtzroman on 06 Jul 2020 00:12:29

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.

Marco Russo's profile image Profile Picture

Joachim Luengas on 06 Jul 2020 00:12:28

RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings

Good idea.

Marco Russo's profile image Profile Picture

Mario Ortiz on 06 Jul 2020 00:12:28

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

Marco Russo's profile image Profile Picture

Reinhard Eilmsteiner on 06 Jul 2020 00:11:49

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. :-)

Marco Russo's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:07:31

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.

Marco Russo's profile image Profile Picture

Márcio Jesus on 06 Jul 2020 00:03:38

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.

Marco Russo's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:01:48

RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings

Needed.

Marco Russo's profile image Profile Picture

Christian Masberg on 06 Jul 2020 00:01:48

RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings

Dearly needed.

Marco Russo's profile image Profile Picture

Cangini Matteo on 06 Jul 2020 00:01:35

RE: Option to use comma as list separator and dot as a decimal point regardless of locale settings

I agree