Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MateuszBI
Advocate I
Advocate I

Time Intelligence in Local Language Only

I have enabled "Time Intelligence" Functinon in PowerBI. It creates hittend table and hierarchy, based on time datetype. The problem is that even if PowerBI and Local date format is set to English, the values in that hierarchy, are still in my OS local language. Where can it be set?

5 REPLIES 5
ggnray
New Member

Do any have any update on this issue, I am also getting Hindi language in date heirarichy. 

Jmenas
Advocate III
Advocate III

Hi @MateuszBI

 

yeah i also create a table using DAX, in my english power BI, and all the days of the week are in English but I need them in German. I try almost everything but nothing actually work except to build the complete report in another language file.

I hope you get a reply! 

konstantinos
Memorable Member
Memorable Member

@MateuszBI First check if you are using the latest PowerBI Desktop. You can read these two topics that answer how PowerBI desktop & Service reads/use  Date & number format settings and region.

 

http://community.powerbi.com/t5/Desktop/Thousand-Separator-and-Decimal-Separator/m-p/22146#M6917

http://community.powerbi.com/t5/Desktop/Regional-number-format-delimiters-in-Europe-PowerBI-Desktop/...

Konstantinos Ioannou

I am working on most up to date PowerBI version. I have changed system date to UK. Date is displayed in the format:

01 January 2008

But Time Intelligence function (new function that creates hidden time dimension table based on date field), still have my local language not English. My PowerBI version is english one.

 

Hello did you ever get a response and found a solution to your issue?

 

I have same issue.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors