Power BI

Needs Votes

Set the data model's default Format, for each Data Type

Vote (653)

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 (76)

Comments (76)

Paul Bailey on 03 Nov 2020 14:35:49

RE: Set the data model's default Format, for each Data Type

This needs more votes. I waste so much time changing this everyday.

Ian Macmillan on 19 Oct 2020 04:42:36

RE: Set the data model's default Format, for each Data Type

A very basic request but no doubt costing countless valuable time globally! I imagine only a tiny fraction of people want to show the full date format that is the current default.

Petrus Scheepers on 03 Aug 2020 09:15:38

RE: Set the data model's default Format, for each Data Type

+1

Amazed MS has not given this any attention in 3 years, despite the volume of customers asking for it.
Who uses long date format anyway?

Power BI User on 06 Jul 2020 00:16:58

RE: Set the data model's default Format, for each Data Type

Please fix this. The default date format is the worst possible format and this request is 3 years old now (I'm sure people have mentioned it before too)

Jennifer T Zelmanski on 06 Jul 2020 00:12:59

RE: Set the data model's default Format, for each Data Type

To have the longest possible date format as the "default" is mind-boggling. Who in the world would consider this format to be the most desired or commonly-used format !? Come on, this should be easy! And should have been fixed years ago, frankly.

Power BI User on 06 Jul 2020 00:10:45

RE: Set the data model's default Format, for each Data Type

Who thought that including the time and day of week was the most commonly used format? At least change the default to something more common but ideally, we should choose ourselves.