Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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?

 

Slicer.PNG

 

Thanks

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

Please create a calculated column to work on it.

 

Column = FORMAT('Table'[Date],"mmmmyyyy")

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

7 REPLIES 7
v-frfei-msft
Community Support
Community Support

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.

 

Capture.PNG

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Updated to Version: 2.68.5432.841 64-bit (April 2019)

 

If I open the slicer it looks like this:

 

Slicer 1.PNG

 

As soon as I scroll down towards the month selected it changes to this:

 

Slicer 2.PNG

 

My data in my dataset is set to:

Slicer 3.PNG

 

But when I click the filter in the dataset it shows like this:

 

Slicer 4.PNG

 

Don't know if that helps?

 

Anonymous
Not applicable

Ok so apparently it only happens from Oct 2018 onwards. The full visual is :

 

Slicer 5.PNG

 

 

By the way, the version I updated to was the one downloaded today. Don't know how you got May 2019

Anonymous
Not applicable

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")

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Thanks!

Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.