date format not correct when displayed in a card

[Anonymous]

Hello community: 

I have a problem when I want to display a date in a card. The following happens:

Here's my data: as you can see the format does not inlcude hours, minutes and seconds. 

But I have the following problem, when I want to show a measure that needs the data from the date column I get hours, minutes and seconds. 

I can't understand why I am getting this error. I have also checked in Power Query and the format selected for the column in 'date' not 'date/hour'. 

I want to be able to display the card without hours, min and secs ONLY the date dd/mm/yy

[Pragati11 · Accepted solution]

Hi @Anonymous ,

As you mentioned you are moving a measure to your card visual, not the underlying column from your data.

In that case click on your measure and on the top ribbon, what is it's format. I think the foremat of your measure is datetime therefore it is displaying it that way. Change it to just date format, then it will display what you are looking for.

Measure are calculations using underlying columns from your data. That doesn't necessarily mean that it will take the same data-type as your underlying column using which it is calculated.

Thanks,

Pragati