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?

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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