Search code examples
powerbibusiness-intelligencedax

Power BI regional settings

I have the following problem: I changed the regional settings to Dutch. This means that number should have the following format: ###.###,## ,and currencies should have the following: €###.###,##

unfortunately this doesn't seem to work (see picture/table in the background) when I do the DAX formatting it doesn't change it to the European format but to the American format.

enter image description here

can anyone help me understand why this doesn't effect my report? I am running the latest version but couldn't find the solution to my problem online. I've tried almost every solution given by Microsoft but non work!

Solution

  • The Locale for import settings only affect imports from untyped data sources e.g. text files.

    The locale used for display is set when the PBIX file is created, based on the windows settings of the machine. It can't be changed through the UI, but there is this workaround you could try:

    https://www.sqlbi.com/articles/changing-the-culture-of-a-power-bi-desktop-file/