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

     

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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