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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.