Forum Discussion
Solved
Date Display Formats
Using Power BI Desktop to create reports and charts. What is the syntax for displaying dates in specific formats. For example, "01/25/2015" instead of "Monday, January 25, 2015". Etc. Thanks!
click on the time field in your model then you can click on Modeling in the Desktop ribbon and pick the desired date format
I'm running into a similar issue when using direct query to a SQL table. The information is properly cast as 'date' within my source table and is rendering fine in the power query editor. However when I view these date fields in a table (or any visual) it is automatically changing it to the long format with no option to shorten.
Supporting images here:
I've checked my regional settings and everything is set to the US. Am I missing something that would preserve the date format (MM-DD-YYYY) that's in my data set rather than PowerBI converting it to (Day of Week, Month DD, YYYY)??