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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
aqsa31
Helper II
Helper II

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

 

aqsa31_0-1683191781745.png

 

 

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @aqsa31 

 

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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