Hi, I am facing an issue where the DAX FORMAT formula is not honoring the locale of the user. For example, in Dutch, the thousand separator is typically a dot (.) while the decimal separator is ...
Piloos
Advocate I
Advocate IIn the meantime, the behavior was confirmed by the Power BI support team but the product team confirmed that this is by design.
When we use the FORMATE function in DAX it will consider formatting a String, and this format will apply on the Analysis server side.
so when you change the settings in service these settings will not apply for visual level using performance analyzer in desktop for both visuals DAX Query is not same and it will not Run as same on service due to FORMATE function in DAX which why you will not see any changes in visual power bi service or for DAX format visual. "
Currently, this is by design