Forum Discussion

Khalid1988's avatar
Khalid1988
New Member
2 years ago
Solved

Change the Date slicer format

Hi all  I have the follwoing Date slicer ( between)  Is their is a way to change how date is formated inside it .. The Date Column is formatted : DD/MM/YYYY while the slicer is showing : MM/...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Khalid1988 

    A prompt appears when you change your region.


    Select Apply changes, and the data will change the format.

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi Khalid1988 -In Power BI, the format of the date shown in a slicer is influenced by the regional settings of your report or Power BI Desktop, rather than the format of the date column in your data model. 

 

 

Go to File > Options and settings > Options.
Under the Regional Settings tab, select the appropriate Locale that uses the DD/MM/YYYY

 

Hope this helps.

  • Khalid1988's avatar
    Khalid1988
    New Member
    2 years ago

    HI 
    Thanks a lot , I implemented this but the data keep the same format !! 
    any suggestions why its not changing 
    regards 

    • rajendraongole1's avatar
      rajendraongole1
      Icon for Super User rankSuper User
      2 years ago

      Hi Khalid1988 This is because of the regional settings configured by default in power bi desktop and device configurations.