Forum Discussion
current default setting
Hi there, I development a dash with charts ans values with decimals e.g. (3.5, 1.4) and percent (14.5%, 13.8%) in power bi desktop the settings its in english It's fine, but In the power bi service the values chance to (3,5 1,4) and percent (14,5% 13,8%) 😞 "," instead of "." , sometimes in spanish browser chance to "," and english browser to "."
How to set default to "." in any browser? maybe power bi settings?
Thanks in advance.
Hi Peter_23 - Open your report in Power BI Desktop.
Go to File → Options and Settings → Options.
Under Regional Settings, choose a locale that uses . as the decimal separator (for example, English (United States)).
Ensure the data model is consistent with these locale settings and re-publish the report to Power BI Service.Some browsers automatically apply language preferences based on the user’s regional settings.You can ask users to adjust their browser language settings to English or a locale that uses "." as the decimal separator if this issue persists in the Power BI Service.
Power BI Service Regional Settings:
Go to Settings in Power BI Service.
Under Settings, navigate to the Regional settings tab.
Change the Language or Locale setting to English (United States) or another locale that uses a dot (".") as a decimal separator. This ensures consistency when viewing reports.similar issue solved thread :
Solved: Re: How to get number in German format - Microsoft Fabric Community
Hope this helps.
4 Replies
Hi Peter_23 - Open your report in Power BI Desktop.
Go to File → Options and Settings → Options.
Under Regional Settings, choose a locale that uses . as the decimal separator (for example, English (United States)).
Ensure the data model is consistent with these locale settings and re-publish the report to Power BI Service.Some browsers automatically apply language preferences based on the user’s regional settings.You can ask users to adjust their browser language settings to English or a locale that uses "." as the decimal separator if this issue persists in the Power BI Service.
Power BI Service Regional Settings:
Go to Settings in Power BI Service.
Under Settings, navigate to the Regional settings tab.
Change the Language or Locale setting to English (United States) or another locale that uses a dot (".") as a decimal separator. This ensures consistency when viewing reports.similar issue solved thread :
Solved: Re: How to get number in German format - Microsoft Fabric Community
Hope this helps.
Thanks, rajendraongole1 I configure the regional settings in power bi desktop, but it don't work, so In power bi service I didn't find the option, permissions access maybe?.
The other option is URL with "&language=en-US" and works!
Hi Peter_23 - In Power BI Desktop gets its default number and date formatting from the Windows Region settings.
You need to make the following settings in Windows Regional Settings.at PBI services, you can find below path to change the language
Hope this helps.
