Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all!
I have created a visualization with data coming in Spanish numeric format (1.000,00). However, in Power BI, it is in UK number format (1,000.00).
I have followed the SQLBI method using Tabular Editor and changed the format there. Also, in Power query Editor, I have changed the country options.
Then I have tried to change the format in Power Query Editor to "Fix decimal Number" or "Decimal Number", and it is doing it in UK format.
Please can you help me to get the correct format number? 😔
Thanks in advance 🙂
Solved! Go to Solution.
Hi @Yolandaca ,
Here's a blog explains the Thousand Separator and Decimal Separator in detail , maybe you will get the solution from this article .
The article mentions changing the language in the system locale, so you can follow his steps to try it .
http://schoennie.blogspot.com/2018/11/thousand-separator-and-decimal.html
Best Regards,
Jay
Hi @Yolandaca ,
Here's a blog explains the Thousand Separator and Decimal Separator in detail , maybe you will get the solution from this article .
The article mentions changing the language in the system locale, so you can follow his steps to try it .
http://schoennie.blogspot.com/2018/11/thousand-separator-and-decimal.html
Best Regards,
Jay
@Yolandaca This is typically based on your local language settings. File | Options and settings | Options | Regional settings (both Global and Current File). That said, you could use Custom Format Strings perhaps: Chelsie Eiden's Duration - Microsoft Power BI Community
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |