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 (87)
RE: Set the data model's default Format, for each Data Type
Please allow us to define our own defaults (number of decimals, date format, thousands separator, etc. Thank you.
RE: Set the data model's default Format, for each Data Type
This needs more votes. I waste so much time changing this everyday.
RE: Set the data model's default Format, for each Data Type
A very basic request but no doubt costing countless valuable time globally! I imagine only a tiny fraction of people want to show the full date format that is the current default.
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.