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.
90 Comments
- 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.
- Yes agree, also should be able to format dates (and all data types) per visualisation and/or per report!
- Agree, I have to change date format for every column for every report. Also, changing date format won't affect slicer !
- 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.
- This would be a really nice quality of life improvement. Supported!
- 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.
- 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?
- Agree with Kevin H comment, this also need to be fixed for default number formatting to set default decimals places, thousand separator, currency code,...
- 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.
- 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??
