cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MateuszBI Regular Visitor
Regular Visitor

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
konstantinos Senior Member
Senior Member

Re: Time Intelligence in Local Language Only

@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
MateuszBI Regular Visitor
Regular Visitor

Re: Time Intelligence in Local Language Only

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.

 

MichaelP Frequent Visitor
Frequent Visitor

Re: Time Intelligence in Local Language Only

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

 

I have same issue.

Jmenas Member
Member

Re: Time Intelligence in Local Language Only

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! 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors