kevhav1's avatar
kevhav1
New Member
8 years ago
Status:
Needs Votes

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

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...
power bi
hholthuis's avatar
hholthuis
Frequent Visitor
1 year ago

I would love this! However I sort of have a workaround now:

  1. Save the PowerBi Desktop file as a project (*.pbip)
  2. Close PowerBi desktop
  3. Find/Replace in the resulting *.tmdl files (I use VS Code but could probably make a powershell or batch script)
  4. Reopen the model (project) in PowerBi Desktop

String to find: "formatString: Long Date"

Replace with: "formatString: dd-mm-yyyy" (or whichever format you prefer)

 

You can even do this for multiple files/models all at once.

Recent ideas