Forum Discussion
Date Display Format MM/YY
I'm trying to display the date in a visual as MM/YY (01/18, 02/18, etc.) instead of January 2018 or 1/01/18, but the option isn't there. Is is there a way to display just month and year without havin...
You just add the column to your Date table, then display that date. I use a MMM-YY style format (Jan-19, Feb-19) for example all of the time, but I only create the column once.
Hi Anonymous ,
Please change the date type in power query by this way.
If you change the date to text, it will break date tables and date intelligence. You need to add a new column to the existing date table and leave the Date field as date format.