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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
filiparibeiro
Helper III
Helper III

Thousand and decimal separator

Does anyone know why after publishing pbi embedded file to a portal it might happen that one person views the thousand separator as a comma and the decimal separator as a dot and other views this switched? I have preset on pbi desktop for the thousand separator to be a dot and the decimal separator to be a comma. 

Thanks in advance!

2 REPLIES 2
ibarrau
Super User
Super User

Hi. By a default setting, PowerBi Service will show dates and separators in the language set by the browser. For example. I develop in a Spanish Power Bi Desktop, but when I publish to my English browser it shows different separators. That is a way to help people from any place to feel confortable with numbers.

I think it might be possible to change it, go to dataset settings and change the tab to "General". You can find about one language

ibarrau_0-1674217478774.png

 

You can read more about this here: https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

I hope that helps


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Hello @ibarrau 
Thanks for your reply! I believe that's not the issue because I just checked the language settings in pbi service and they are right (set for Portugal as it should be in this case). Any other suggestions you might have? 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors