Forum Discussion
Date and number formatting
Hi everyone,
I have exhausted all resources I could find, but cannot find why my frontend is not showing the date/number formatting I want:
As we can see the formatting is all in US style, with M/D/YYYY and dots for decimals and commas for thousands (1,000.00). However I want it to be in EU style with DD/MM/YYYY and numbers as 1.000,00.
Now the source tables are formatted correctly:
Also the regional settings are adjusted:
So where can I look next to get the formatting correctly in the frontend?
Thanks
Maarten
Hi Maarten_BI ,
Thanks for reaching out to the Microsoft fabric community forum.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team
11 Replies
- FBergamaschi
Super User
If you are asking how to get the EU format in the cloud, no way as the machine to which you publish uses the US formats. The only thing you can do is force them format you want with a dedicated measure, using the FORMAT DAX funtion
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
I'm using PowerBI desktop.
- FBergamaschi
In that case somesettings must be in the visual
pease create a new matrix in a new page and check that the format is correct in that matrix
Come back to me with this information pls
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
