Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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];"DD...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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?

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago
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,
MFelix
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes I have that configured as Spanish, the day/month calculated fields are still in english. Any idea?

Thank you!

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago

    Hi 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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 )
 )