How to change date and time yo just date in a datacard

[Sonyat810]

How to only show date and not time in a datacard field, Its disabled for me.

[BCBuizer]

Hi @Sonyat810 ,

If you click on the Advanced Tab, you'll have the option to unlock the datacard which allows you to edit it:

Once unlocked, you can use the Text Function to remove the date, assuming Parent.Default is referencing a Date/Time column:

Text(Parent.Default,"dd/mm/yyyy")

[Sonyat810]

It's not updating my excel sheet now. 

[BCBuizer]

Hi @Sonyat810 ,

Can you please provide a bit more context? What is not updating your Excel sheet?

[Sonyat810]

Ok, I see that its updating my excel sheet which is connected to power BI. But I still see the timestamp

[Sonyat810]

[BCBuizer]

Hi @Sonyat810 ,

As you'll see in other posts in the community, Excel isn't the best data source to use, especially for date/time since there is no validation. I suggest you either 1. change data sources, for instance to Sharepoint (where you can disable time values) or 2. accept that the time value is there and implement solutions such as above to make sure the time value is not displayed.

[Sonyat810]

I remove the hour and mins, but it keeps showing up in my excel sheet

[Sonyat810]

My excel sheet is linked to power bi

[BCBuizer]

Hi @Sonyat810,

There is no safe way to remove the time from Excel because the Excel connector will keep sending time values. This is why you should choose to live with it, or move to a data source that can accommodate your request.