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 (79)
RE: Set the data model's default Format, for each Data Type
Good information, thankssehackear.top
RE: Set the data model's default Format, for each Data Type
ThanksHackear Instagram Hackear WhatsApp Hackear Facebook
RE: Set the data model's default Format, for each Data Type
Top, thanksHackear Instagram Noticias sobre facebook instagram noticiario 98hy5
RE: Set the data model's default Format, for each Data Type
For currencies, this would also be very helpful. Please add this!
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.
RE: Set the data model's default Format, for each Data Type
Definitely needed!
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.
RE: Set the data model's default Format, for each Data Type
Is it too late to write to Santa for this? This is really tedious to work around.
RE: Set the data model's default Format, for each Data Type
Every single time I bring in a date I physically have to change each one. Even an option to copy formatting from one date to another would save me hours of boring repetition(Also the ability to change formats when editing in Power BI Service)
RE: Set the data model's default Format, for each Data Type
It's such a basic requirement. I can't believe this still hasn't been addressed!