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 (85)
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
RE: Set the data model's default Format, for each Data Type
The amount of time it takes to format the date and amounts is like watching water boil....
Being able to define defaults in the theme would be great.
At the very least allow us to choose multiple columns at a time and apply the format to those all at once vs one at a time.
RE: Set the data model's default Format, for each Data Type
Even if you can't set a default, the current default setting is the most ridiculous setting i have ever seen. Developers must have been smoking something
RE: Set the data model's default Format, for each Data Type
The default format is absolutely awful.
RE: Set the data model's default Format, for each Data Type
Definitely I vote this!
RE: Set the data model's default Format, for each Data Type
I agree. And I agree with Bernat; the default date format is just dumb. How often does anyone really want a date in that long format??
RE: Set the data model's default Format, for each Data Type
Completely crazy that this feature doesn't exist. I do NOT want each user to have his own format, I want to force it globally. Dates should always be YYYY-MM-DD, numbers should always have dot decimal separator, etc.
RE: Set the data model's default Format, for each Data Type
Agree with Kevin H comment, this also need to be fixed for default number formatting to set default decimals places, thousand separator, currency code,...
RE: Set the data model's default Format, for each Data Type
I would be glad even if only the default value was not such an obnoxious and long format as it is now...
isn't there any xml file which can be tuned or something?
RE: Set the data model's default Format, for each Data Type
PLEASE implement this feature! Very time consuming to have to go in to MODELING & have to set default format for date field on every file pulled in. I am currently leaving any that are "report only" as text to save time.