Date column not recognized as Date in Data View despite setting UK locale

[Rufyda]

I have a dataset from a UK bank that includes a date column. I tried setting the timezone/locale to the United Kingdom, but the column is still not recognized as a Date. As a result, in the Data View, the column does not appear as a date type, and I cannot perform date-based operations on it.

Dataset source: UK bank

Column format: Standard date strings (e.g., DD/MM/YYYY)

Action attempted: Set timezone/locale to UK

Issue: Column still not recognized as Date

Could you advise how to make the system recognize this column as a Date?

Thank you!

[Rufyda]

https://drive.google.com/file/d/1tpA-rpYR57owlpr3sapnSna979hoxGXx/view?usp=sharing 

[danextian]

Hi @Rufyda 

It already shows as date type in Power Query. If the date column is on the many side of and is being used in a relationship, it won't show a date icon before it but the data type should show as date.

[Rufyda]

I have one Table 
no relationship!

it appears in power query as data but text in data visu 

[anilelmastasi]

Hello @Rufyda ,

I could not understand. It shows date type in power query. Can you explain it more please?

[anilelmastasi]

If I have to guess, in Table View select the Date Joined column and in Data Type section select Date too.