Reply
avatar user
Anonymous
Not applicable

Date hierachy and month names

Hi

 

When I use a date as a hierachy, my month names are in english (right on picture), but when I use the same field "flat" (left) they are in my regional language.

 

It's like it ignores regional settings? In options, my regional setting is correct - also, it works on the flat dates.

 

Thanks in advance

 

datoer.png

2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi BoRaun,

Could you please tell us which language does it display after you importing the date? Please check it in Data tab.

11111.png

If you import date after changing the regional setting, it will set the date format to the language you set, besides, please check what's data type of the date column.

>>When I use a date as a hierachy, my month names are in english

This is because the model language is English, the language Power BI Desktop uses when creating hidden date tables from date fields

Best Regards,

Teige

avatar user
Anonymous
Not applicable

Hi TeigeGao

 

Thanks for Your reply.

 

The date is from a date dimension created with CALENDAR, in data tab the date is in danish (as desired). The data type is date. The dates used in parameters for the calendar function, are danish.

 

>This is because the model language is English, the language Power BI Desktop uses when creating hidden date tables from date fields

 

Sorry, I don't fully understand You - I use the danish Desktop version, and in PBI portal my language is also danish.

 

Thanks

Bo

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)