Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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).
@v-shex-msft @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?
Try something like this.
HI @alejandrofm,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsYes I have that configured as Spanish, the day/month calculated fields are still in english. Any idea?
Thank you!
Hi @alejandrofm,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi! @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).
@v-shex-msft @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?
Hi @MFelix ,
I am having similar problem on my side. We have created dataset with Switzerland (De) regional settings. And now when we use format function, we are always getting german day names even if our regional settings are set to English (US).
It would be best if we can fix this in dataset somehow (and i am trying to avoid switch with list of day names in english)
Calendar = ADDCOLUMNS( CALENDAR( "2019-01-01", "2019-12-31"), "WeekDay", FORMAT ( [Date], "dddd" ), "WeekDayNo", WEEKDAY([Date],2 ) )
Oh, I can see only now, that model language is set only once, when report is create and is not able to change.
I guess this means i will need to create another dataset with correct model settings
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |