Forum Discussion

Benoit_L's avatar
Benoit_L
Icon for Advocate II rankAdvocate II
8 years ago
Solved

Display dates in French (months, days)

Hello !   I have created my own calendar table. https://community.powerbi.com/t5/Desktop/How-do-i-create-a-date-table/td-p/23896   I wish PBI to display the following parts of the date in French...
Need Help
  • Benoit_L's avatar
    Benoit_L
    8 years ago

    Dear Community, dear PaulDBrown

     

    I got an explanation from the support / dev team, and it is not a good news :smileyfrustrated:

     

    The FORMAT functions (and all derived) show a language that is one of the DataModel.
The language of the DataModel depends on how the PBIX was created originally.

Your PBIX might have been created on a US/UK machine/setting that make the FORMAT to display English

The bad news is this setting cannot be reverted!

Once the PBIX works you can use this one to rebuild the report.

    My own tests confirmed that solution. I just hope using a PBIT template will help me not waste hours of work in rebuilding my whole PBIX.

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
8 years ago

Benoit_LI have the same issue, albeit in Spanish, whenever I try to include a date using FORMAT in for example a string. I posted a thread about it, and the solution then appeared to be to dowload the Power BI Desktop version in Spanish (which is a bit of a nuisance). Here is the thread:

 

Dates inconsistent when using FORMAT

 

Today, however, I don't even have the option to display dates in DD/MM/YYYY format under the Date type options in the Modeling pane and including a TODAY() function renders the date etc in English (which is not what was happening previously: TDOAY() used to render the date in Spanish). I think this is a bug which has appeared in the latest version of PBI Desktop and which also affects the way the thousands and decimal point indicators are displayed.

 

It would also be nice if we had the option to choose how dates etc are displayed when publishing to the online service.

 

Edit: I've just published one of my reports and it seems that the online service respects the language settings (decimal and thousands separator; Dates if not using FORMAT - dates using FORMAT are displayed in English). So it appears the locale settings bug is intrinsic to the Desktop app. Or does the online service apply its own "local" settings?

 

 

Benoit_L's avatar
Benoit_L
Icon for Advocate II rankAdvocate II
8 years ago

PaulDBrown

Thank you for the reply, but none of those ideas work for my issue.

My Desktop as explained was already in French, I tried both parameters (OS locale and French language)

And I looked at the result on the online service, and it's the same (months and days displayed in English)

 

Surprisingly decimal and thousands separator are correclty using French settings !

  • Benoit_L's avatar
    Benoit_L
    Icon for Advocate II rankAdvocate II
    8 years ago

    Dear Community, dear PaulDBrown

     

    I got an explanation from the support / dev team, and it is not a good news :smileyfrustrated:

     

    The FORMAT functions (and all derived) show a language that is one of the DataModel.
The language of the DataModel depends on how the PBIX was created originally.

Your PBIX might have been created on a US/UK machine/setting that make the FORMAT to display English

The bad news is this setting cannot be reverted!

Once the PBIX works you can use this one to rebuild the report.

    My own tests confirmed that solution. I just hope using a PBIT template will help me not waste hours of work in rebuilding my whole PBIX.