Forum Discussion
Slicer visual
Hi, Currently my slicer is showing the full date but selections are all in MMM YYYY. Is there any way I can make the slicer show the same format as my options? IE MMM YYYY? Thanks
Hi Anonymous ,
Please create a calculated column to work on it.
Column = FORMAT('Table'[Date],"mmmmyyyy")
Ok so apparently it only happens from Oct 2018 onwards. The full visual is :
By the way, the version I updated to was the one downloaded today. Don't know how you got May 2019
UPDATE:
If I sort the data in descending order and have the most recent month at the top, it does it for the last 8 months of the new list IE:
Jun 2010 to Jan 2011
Hi Anonymous ,
Please create a calculated column to work on it.
Column = FORMAT('Table'[Date],"mmmmyyyy")Thanks!
By the way, for anyone else reading this, when you use the above solution, it sorted the column alphabetically. IE April first then August etc. All you do is select the the column and sort by the original date column.