Kevin H on 08 Sep 2017 04:29:54
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.
- Comments (84)
RE: Set the data model's default Format, for each Data Type
+1
Amazed MS has not given this any attention in 3 years, despite the volume of customers asking for it.
Who uses long date format anyway?
RE: Set the data model's default Format, for each Data Type
Please fix this. The default date format is the worst possible format and this request is 3 years old now (I'm sure people have mentioned it before too)
RE: Set the data model's default Format, for each Data Type
To have the longest possible date format as the "default" is mind-boggling. Who in the world would consider this format to be the most desired or commonly-used format !? Come on, this should be easy! And should have been fixed years ago, frankly.
RE: Set the data model's default Format, for each Data Type
Who thought that including the time and day of week was the most commonly used format? At least change the default to something more common but ideally, we should choose ourselves.
RE: Set the data model's default Format, for each Data Type
Crazy that this has not been done yet. Very disappointing.
RE: Set the data model's default Format, for each Data Type
Yes, very important, or at the _very_least_ make the default format be the shortest possible.
RE: Set the data model's default Format, for each Data Type
This function is urgently needed. It takes a lot of time right now.
RE: Set the data model's default Format, for each Data Type
It is ridiculous that this can't be done. Super common, super labor intensive.
RE: Set the data model's default Format, for each Data Type
This is really needed! Common date format as a default is important. I am quite fed up with changing the format every time. Nobody is using this existing default format anywhere...
RE: Set the data model's default Format, for each Data Type
Totally agree such a waste of effort to have to manually change multiple columns - everyone has a favourite data format and should have a default option for each data type. Thanks