Change date hierarchy language from German to English in existing report

[piotrgrendus87]

Hello.
I would like to change the language in the date hierarchy section, the report was created with regional settings in German.
Currently I have changed the settings for PowerBI Desktop and for this report to:

Global settings:

Current File:

but my date hierarchy is still in German language

Is it a way to solve this issue ?

Regards Piotr.

[deloford]

This is such a frustrating bug in PowerBI, somebody must have created this huge report years ago in Spanish and now the only way to change the language is to rebuild the entire thing from scratch, quite bizzare that PowerBI still doesnt support regionalisation like every other web and reporting application?

[amitchandak]

@piotrgrendus87 , Try this.

Uncheck the Auto date time intelligence at the file level. Save. Then again go back and enable that and save.

The setting is under file-> Options and Settings -> Options

[piotrgrendus87]

I tried this method, but it did not help.

[Anonymous · Accepted solution]

Hi @piotrgrendus87 ,

It depends on the language of the model at the time of creation. This is also mentioned in the documentation.

Auto date/time in Power BI Desktop

You may consider using YEAR(),DAY(),FORMAT() functions to create calculated columns to replace the date hierarchy.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data