Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @Anonymous ,
Please create a calculated column to work on it.
Column = FORMAT('Table'[Date],"mmmmyyyy")
Hi @Anonymous ,
Based on my test using the Power BI desktop version : 2.69.5467.1251 64-bit (May 2019). I cannot reproduce your issue here. Could you please update your Power BI desktop and try again.
Updated to Version: 2.68.5432.841 64-bit (April 2019)
If I open the slicer it looks like this:
As soon as I scroll down towards the month selected it changes to this:
My data in my dataset is set to:
But when I click the filter in the dataset it shows like this:
Don't know if that helps?
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |