Set the data model's default Format, for each Data Type

[kevhav1]

For example: when the Power BI data model first creates a column with Data Type = 'Date', by default that column is formatted like 'Wednesday, March 14, 2001 (dddd, MMMM d, yyyy)'. Then, I always go to the Modeling tab, and use the Format drop-down to change it to '2001-03-14 (yyyy-MM-dd)'. Instead, I would like to be able to go into the "Options" menu in Power BI Desktop, and have a section where, for each Data Type (or at least Date, Date/Time, Decimal Number and Whole Number), I can set the default Format. So that I don't have to manually change it every single time! It would also be nice to add this as a setting in the Power BI Service. Set default Formats (maybe for the entire tenant, or maybe by user?) when creating a data model using the Power BI Service.

[mira_nikkila]

It would help a lot, if the default format for date would not be the long but short one. Who uses long one in any report?

[Tmullins]

YES!!

It's maddening to have to do this EVERY SINGLE TIME. We work with dates a lot, as I'm sure everybody else does. It seems small, but having to do this over and over and over again becomes a serious time suck.

[andriy2]

yes, please make this available!

thank you

[aedmunds1]

This is insane ... I just switched from Dataset to Dataflow ... reimported all my 70 (yes SEVENTY) tables with at least 2-4 dates each ... and have had to go through and change every date from the default to a short date of my choosing.

What a waste of time for a simple feature ...

Just make it two steps ...

a) the Format desired for Date, Time and Date/Time fields

b) override and enforce globally tick box

Come of PowerBI gurus ... let's get it happening

[cw2002]

Can't believe this isn't a functionality everywhere, just hoping now that my client doesn't ask me to change the format, cause I'll have to go and edit something like 40 columns manually.

[karthik_p1]

I work with multiple tables and each table has about 7-8 date fields. This is a real pain to manually change the date format to Short Date every time.

Also, why can't I do multiple select columns in the Data Tab in PowerBI Desktop?

[Phil_Plummer]

I mean, who really cares what day of the week a date is on? This is nuts!

[simapatel]

Yes, please add this functionality.

[david27]

How is this minor change still not made five years on from the original ticket? Come on.

[jf15861]

Basic functionality that is sorely lacking, please add the option to set data types as a default of the developer. We know our data better the MS.