Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    Please create a calculated column to work on it.

     

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

     

7 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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