cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

About Language

hi there ;

 

i have a column as below called "delivery date" and as you see it has month name (in turkish ) and year format .

 

even on power bi , i selected english language it seems in turkish also still my date formats ara coming in turkish ,  i need to show dates in english , how can i solve this issue , could you pls help me.

 

thanks 

 

Capture-1.JPG

 

Capture-2.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: About Language

Hi @erhan_79 ,

 

You need to use English version of Power BI Desktop firstly.

Then you can configure the Date in Power Query Editor like @harshnathani  said,

 

1. Right-click the date column and select Using Locale.

 

About1.jpg

 

2. Change the date type to date and locale to Turkish(Turkey). The result like this,

 

about2.jpg

 

about3.jpg

 

If it doesn’t meet your requirement, you can create a new date column and check it again.

Date_test = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]),DAY('Table'[Date]))

 

about4.jpg

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: About Language

HI @erhan_79 ,

 

Go to Query Editor.

 

Click on the Icon Format and try Use Locale. Select Date or Date/Time and then format based on your region.

 

1.jpg

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Highlighted
Post Patron
Post Patron

Re: About Language

dear @harshnathani 

 

i tried as you explain but again it is coming turkish on pbı desktop date format selection area as beolow , it is not turning to english.

 

it is like something my own program still in turkish but all the options i set up to english allready 

Capture-2.JPG

Highlighted
Community Support
Community Support

Re: About Language

Hi @erhan_79 ,

 

You need to use English version of Power BI Desktop firstly.

Then you can configure the Date in Power Query Editor like @harshnathani  said,

 

1. Right-click the date column and select Using Locale.

 

About1.jpg

 

2. Change the date type to date and locale to Turkish(Turkey). The result like this,

 

about2.jpg

 

about3.jpg

 

If it doesn’t meet your requirement, you can create a new date column and check it again.

Date_test = DATE(YEAR('Table'[Date]),MONTH('Table'[Date]),DAY('Table'[Date]))

 

about4.jpg

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Top Solution Authors
Top Kudoed Authors