Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

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

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).
Status: Completed
Comments
fbcideas_migusr
New Member
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/
fbcideas_migusr
New Member
Status changed to: Completed