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.
Go to Solution.
Select your Column Date and go to the Modeling tab. there is a data type there and format where you can change it.
Hi @joeytsui Use the below formula to create a calculated column.
thank you so much./Joey
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.