cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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?

4 REPLIES 4
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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors