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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.