cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Date (formatted long date) doesn't translate in browser's language

I format dates in a report's measure :

"Projects selected running from " & 
FORMAT(MIN(FACT_COST_ACTIVITY[DATE_DEBUT_PROJET]);"Long Date") & 
" to " & 
FORMAT(MAX(FACT_COST_ACTIVITY[DATE_FIN_PROJET]);"Long Date")

 

Report is connected using direct query (live connection) to a tabular model. 

The development environment is done on a French Windows, PBI is configured to use Windows language and model is set to use the application language.

     2019-12-04 08_39_20-.png

Current file regional setting is set to French (as there is no 'universal' / "use system" option.) but that doesn't seem to matter much.

   

      2019-12-04 08_39_42-TPL - 1.2.1.2 - Power BI Desktop.png

 

 

 

PBI service is set to use browser language.

 

      2019-12-04 08_41_04-vm-test1 - Remote Desktop Connection.png

 

 

 

When accessed from an English configured computer (both Windows and Chrome are set to English), the months are still in French.

       2019-12-04 08_44_23-vm-test1 - Remote Desktop Connection.png

 

Result : 

      2019-12-04 08_47_50-vm-test1 - Remote Desktop Connection.png

 

Am I missing something?

What do I need to change in order to get the months to translate in user's language?

2 REPLIES 2
Community Support
Community Support

Hi @6mon ,

I suggest you to create your report in an English environment. Your development language is French, and the browser's language setting does not automatically translate your basic data into English.

1. Change your data format on your computer:

region.PNG

2. Change the Regional settings in Power BI Desktop before you create a report.

region2.PNG

region3.PNG

3. For data in 'Text' mode, translate it manually.

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Won't cut it as I don't want to set it to english, I want it to be in the user's browser language.

 

Also I think it uses the tabular model (database) culture...  Which is enhireted from the Analysis Server property. 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors