Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Show date slicer values in long date format

Is it possible to show the long date format in the date slicer? Instead of how the values are displayed in the picture below, I want the slicer value to be in the 'dd/mon/yyyy' format.  

 

e.g 4-Jan-2021  25-Apr-2023

 

 

 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous 

     

    This is not possible currently. You can find the following description from Create a numeric or date range slicer in Power BI - Power BI | Microsoft Learn

     

    When you use a slicer to display or set a range of dates, the dates display in the Short Date format. The user's browser or operating system locale determines the date format. As such, it will be the display format no matter what the data type settings are for the underlying data or model.

     

    You could, for example, have a long date format for the underlying data type. In this case, a date format such as dddd, MMMM d, yyyy would format a date in other visuals or circumstances as Wednesday, March 14, 2001. But in the date range slicer, that date displays in the slicer as 03/14/2001.

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.