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 (77)
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.
RE: Set the data model's default Format, for each Data Type
This would be a really nice quality of life improvement. Supported!
RE: Set the data model's default Format, for each Data Type
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.
RE: Set the data model's default Format, for each Data Type
Agree, I have to change date format for every column for every report.
Also, changing date format won't affect slicer !
RE: Set the data model's default Format, for each Data Type
Yes agree, also should be able to format dates (and all data types) per visualisation and/or per report!
RE: Set the data model's default Format, for each Data Type
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.