Date Format issue

[joeytsui]

Hi All,

I have a table which is contain a date field, and i change it to "date only" on power query, and it shown correct under power query and slicer in PBI desktop.

however i create a table show customerno and lastest date, the it show the full date, see attached photo.

Is it possible to show the short date format on the table, just like the slicer and power query ?

Thanks in advance.

Joey

[mussaenda · Accepted solution]

Select your Column Date and go to the Modeling tab. there is a data type there and format where you can change it.

[joeytsui]

thank you so much./Joey

[Ani1991]

Hi @joeytsui 

Use the below formula to create a calculated column.

Formateddate = FORMAT(DateDim[Date],"dd/MM/yyyy")

Thanks,

Ani