Skip to main content

Power BI

Needs Votes

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

Vote (702) Share
Kevin H's profile image

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 (82)
Kevin H's profile image Profile Picture

Spencer Abbott on 05 Sep 2024 13:29:23

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

Good to know this very basic idea has been floating for 4 years now, and is still an issue.

Kevin H's profile image Profile Picture

Sam Wagner on 30 Aug 2024 13:12:54

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

It's rather odd that a BI/visualization application would use the longest date format possible for its default. First thing I have to do it manually reformat every single date column to short date. What's increase the agitation is that there is no option to select and change all at once. Terrible oversight...twice...by developers!!

Kevin H's profile image Profile Picture

Richard Robinson on 28 Aug 2024 03:34:33

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

Why are you always overlooking the basics, Microsoft. This should have been an option since day 1.

Kevin H's profile image Profile Picture

Daniel Cassidy on 25 Jul 2024 10:38:46

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

I agree with everyone else, 90% of users don't want the long date format; it's odd that the default is a format most people don't want.

Kevin H's profile image Profile Picture

Lee Colbert on 06 Jun 2024 11:31:18

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

Why default the date format to long anyway? I'm curious to know what percentage of PowerBI users prefer the long date format as the default? Manually changing 90% of the date columns in my PowerBI models is not fun! It's a time sink!!

Kevin H's profile image Profile Picture

Luis Machain on 28 May 2024 23:24:54

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

Just change the default date format to short date instead of long date, nobody uses long date

Kevin H's profile image Profile Picture

Martin Steenberg on 03 Apr 2024 11:46:44

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

For currencies, this would also be very helpful. Please add this!

Kevin H's profile image Profile Picture

Dan Coates on 19 Mar 2024 12:10:58

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

I can't believe this doesn't exist either! It also needs one for default currency symbol too.

Kevin H's profile image Profile Picture

Annemie Van Dijck on 05 Mar 2024 13:35:01

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

Definitely needed!

Kevin H's profile image Profile Picture

Sally Newell on 08 Jan 2024 09:37:56

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

Totally agree, there should be an option to set your own default for dates.It would be useful for other data types, like currency, too.