Forum Discussion
Advocate IIDisplay dates in French (months, days)
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.
Advocate IIThank 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 !
Advocate IIDear 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.