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 (82)
RE: Set the data model's default Format, for each Data Type
Good to know this very basic idea has been floating for 4 years now, and is still an issue.
RE: Set the data model's default Format, for each Data Type
It's rather odd that a BI/visualization application would use the longest date format possible for its default. First thing I have to do it manually reformat every single date column to short date. What's increase the agitation is that there is no option to select and change all at once. Terrible oversight...twice...by developers!!
RE: Set the data model's default Format, for each Data Type
Why are you always overlooking the basics, Microsoft. This should have been an option since day 1.
RE: Set the data model's default Format, for each Data Type
I agree with everyone else, 90% of users don't want the long date format; it's odd that the default is a format most people don't want.
RE: Set the data model's default Format, for each Data Type
Why default the date format to long anyway? I'm curious to know what percentage of PowerBI users prefer the long date format as the default? Manually changing 90% of the date columns in my PowerBI models is not fun! It's a time sink!!
RE: Set the data model's default Format, for each Data Type
Just change the default date format to short date instead of long date, nobody uses long date
RE: Set the data model's default Format, for each Data Type
For currencies, this would also be very helpful. Please add this!
RE: Set the data model's default Format, for each Data Type
I can't believe this doesn't exist either! It also needs one for default currency symbol too.
RE: Set the data model's default Format, for each Data Type
Definitely needed!
RE: Set the data model's default Format, for each Data Type
Totally agree, there should be an option to set your own default for dates.It would be useful for other data types, like currency, too.