Forum Discussion
Change language for FORMAT function and hierarchy
Hi, I'm developing every report in english because is easier to find tutorials online in that language, I allways code in english.
Now I have to plublish a report that uses FORMAT(table[date];"DDDD") to get the day of the week, it returns the result in english. I downloaded the spanish version of PBI, load the file, change the language, add again that column, and it's still in english.
Have the same problem when using date hierarchy, it didn't translate those either (the ones that are created automatically when drag a date field to an graph axis)
Any idea of how can I solve this?
Thank you!
Hi! MFelix I checked that, is all configured that way, hyerarchies still are in english, format too (My OS is in spanish configured with spanish locale, same as IE).
Anonymous MFelix Ok, this is the current situation, I CAN'T use FORMAT in DAX, because I lost the LOCALE configured before, BUT I CAN use Extract month from date in query editor and it returns the date in spanish. Does that make sense?
8 Replies
Try something like this.
FORMAT('DATA'[Date];"MMMM";"pt-br")- Hi Anonymous,
Regarding the regional settings this is unique to each report and by default it will pick up the OS options however you can change this for a specific file.
Open the report you want to have in spanish and on FILE -> OPTIONS -> REGIONAL SETTINGS change it to Spanish.
No need to download the spanish version or any other.
Regards,
MFelixHi Anonymous,
Be aware that if your computer is with regional settings in english all the date columns will appear in english and not in Spanish.
As you can see below if I have the OS in English although the PBIX file is in Spanish dates are English when OS is Spanish everything is Spanish.
So if your users will have the system in Spanish they will see everything correct.
Regards,
MFelix
HI Anonymous,
I'd like to suggest you try to use 'use locate' option to manually setting content type to help query editor format your data type more accuracy.
Local date formats in Power BI
Regards,
Xiaoxin Sheng
