Date Format Issue

[Zaky]

Hi,

Can anyone help me to solve this... I have a data with custom date format dd/mm/yy. But when i create visual, why it appears long format date starts with yy/mm/dd? 

How can i change it to be seen as per chart below starts with dd/mm/yy?

Thanks

[moumipanja · Accepted solution]

1. Go to query editor.

2. In your table, right click on the date column and duplicate it first so that we still have the original column untouched.

3. Right click on your duplicate column, say Date-Copy, and select Change Type -> Using Locale

4. Set Data Type as Text, Locale as English (United Kingdom).

5. Close and Apply

6. Use Date-Copy along with your calculation. In the visual, sort it in ascending order.

[Zaky]

Hi  @moumipanja,

Thanks for the amazing assistance!