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.

[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.

[v-cgao-msft · 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