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 (84)
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.