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 (85)
RE: Set the data model's default Format, for each Data Type
Congratulations to Microsoft, for having a product where everyone in the world have the same problem since day 0 and they lack the effort to solve!
RE: Set the data model's default Format, for each Data Type
This takes a long time. If we could choose how we wanted to show dates as a Default - we could choose our preference. Even just once per report. Also - Date Hierarchy... mostly, I use plain date insteadCurrency - let us set it once per report - and then use the same currency.... These are all time consuming to chance and error prone areas.
RE: Set the data model's default Format, for each Data Type
You do sometimes get the feeling when using Microsoft products that you're stepping back into the dark ages. Having to manually change things every time we create new reports is staggeringly unhelpful and extremely time consuming. Could someone, somewhere, please look into resolving some of these very basic design flaws in order that we can actually get on with doing what we're supposed to be doing.
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.
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!!
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.
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.
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!!
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
RE: Set the data model's default Format, for each Data Type
For currencies, this would also be very helpful. Please add this!