- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi BoRaun,
Could you please tell us which language does it display after you importing the date? Please check it in Data tab.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
08-06-2024 01:59 PM | |||
06-20-2024 04:48 PM | |||
06-10-2024 09:07 AM | |||
12-02-2023 09:12 AM | |||
04-23-2024 05:54 AM |
User | Count |
---|---|
104 | |
75 | |
43 | |
39 | |
32 |
User | Count |
---|---|
170 | |
90 | |
65 | |
46 | |
44 |