The ability to change the format of a date similar to in Excel where you can base it on a YYYY, MM, DD, etc.
13 Comments
- It will be very helpfull !!!
- Create a new column and enter this formula AuditDate2 = FORMAT([AuditDate], "MM-YYYY")
- Dates are always displayed in reports as e.g. Monday, 1 January 2016. How do I display it as 1/1/2016?
- Will, this is a great option - but can we specify our own? For instance, I have a need to display MMM or MMMM (just the month name. The designer appears to "know better" and only lets me pick from a pre-defined list of options.
- I agree, custom Date formatting would be incredibly useful. Dennis's solution above (using a calculated column) should work, but since the new column is treated as text instead of as a date, it shows up alphabetically instead of chronologically.
- I want to format DateTime to Date and it works fine but it trims the Zero. or does not keep zero in the front of single month value(01,02,etc). So when converted and sorted, it displayed like text. 2015/1, 2015/10,2015/11, 2015/12, 2/2015/2, 2015/3 and so on.
- This is marked as completed, but I don't see the feature in PowerBI Desktop (I have the latest). I can only format dates from a selection list.
- Hi, I have a basic doubt on working in "Direct Query mode". Would the formatting changes i make in my Power BI Desktop in direct query mode influence the data storage in the underlying database or its just these formatting changes are local to my PC or pbix file. Regards, Srinivas
- Is it possible to set the dateformat for the date that we have already entered???
