Card date format does not match data model

[thatguyadam]

Hi All,

BI newbie with what I hope is a simple question, which is: why doesn't the date formatting in the below Card match that of the data model?

BI Desktop > Regional Settings > Locale for import =  English (United Kingdom)

Data Model

SQL live connection, the column in question is directly queried and has a Data Format in BID as Date. As shown in the results this returns using the regional format of DD/MM/YYYY

Report (Card)

A Card using this field has the Data Label is showing the long date for some reason, as below:

The Card is set to show the very latest date from the column, just through its settings not using DAX or anything clever. I have renamed the category for the sake of the report so to be clear Baseline Finish == baselinefinishdate

I can't seem to find any independent date-style formatting options for the Card itself, and presumed it simply took that of the model. Any idea what I may be doing wrong? The desire is for the Card to display a DD/MM/YYYY format.

I have run a few tests to ensure the 'date is a date' and not any kind of string and have access to the transformations that only work on dates, so happy with that.

Any advice would really be appreciated.

[ebeery · Accepted solution]

@thatguyadam "data format" is controlled separately from "data type".  What you show in the first screenshot is the data type.

To adjust the data format, select the column in Power BI, and from the "Column tools" section on the ribbon, click on the "Format" dropdown, and select your desired format

[thatguyadam]

Thank you @ebeery that done the trick. Didn't even occur to me to select the field itself from the Fields pane, once I did the steps you described done exactly what I needed. 

[thatguyadam]

May or may-not matter, but if I set to date-time I do get a dd/mm/yyyy hh:mm format