Set the data model's default Format, for each Data Type
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.
This function is urgently needed. It takes a lot of time right now.
It is ridiculous that this can't be done. Super common, super labor intensive.
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...
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
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.
Tim Stepp commented
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
The default format is absolutely awful.
Definitely I vote this!
Jen Z commented
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??
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.
Agree with Kevin H comment, this also need to be fixed for default number formatting to set default decimals places, thousand separator, currency code,...
Bernat Agulló commented
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?
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.
Gabriel Lainesse commented
This would be a really nice quality of life improvement. Supported!
Glad to find this! I ran into this issue yesterday, really frustrating! New data source for visualizations so I go into EDIT QUERIES & verify data types for date/currency fields. Then I notice that 1 dashboard is displaying something like 10 decimal places for totals on a currency field & the dates are displaying DDD MM/DD/YYYY. Quickly check underlying Excel Workbook - nope, everything is 2 decimal places. Double check EDIT QUERIES... find need to go into MODELING to set 2 decimal places on the currency fields & MM/DD/YYYY on date fields.
This should all be under OPTIONS, the ability to set default formatting for ALL date & numeric fields instead of needing to set this twice! MAJOR waste of time.
Agree, I have to change date format for every column for every report.
Also, changing date format won't affect slicer !
Yes agree, also should be able to format dates (and all data types) per visualisation and/or per report!
Kevin H commented
Also, for practically every single 'Decimal Number' column I create, I change the Format to add the thousands separator (comma).
Just another example where it would be nice to be able to simply set my own default Format.