Forum Discussion

SusieN's avatar
SusieN
Regular Visitor
5 years ago

Chiclet Slicer Locale Issue on Dates

We are pulling data from a SharePoint List configured as English UK.  In PowerQuery Editor date/time fields are initially identified as text strings even though Auto date/time for new files is set on.  When Change Type from Text to Date/Time, in Editor the date appears in the correct format.  But when I Apply the changes and try to use the Date/Time field as a Category for the Chiclet Slicer, the dates revert to US format.  I want to sort the slicer by Date descending so am stuck with either leaving the date as Text which means the sequencing is wrong but the date/time looks right, or converting to DateTime and then the display in the slicer is wrong.  The same fields are displayed correctly as UK format DateTime in tables so just seems to be something with the Chiclet Slicer.   But there are no settings on the Chiclet itself that I can find.   

 

Any tips please?!

Need Help
Tips and Tricks

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    SusieN ,

     

    I can't reproduce your question at the moment. Can you provide more information or screenshots, such as the converted date format, specific steps, etc.?


    Looking forward to your reply.

     

    Best Regards,
    Henry

     

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

  • SusieN's avatar
    SusieN
    Regular Visitor
    5 years ago

    Hi Henry, thanks for the reply.  I will upload some screen shots  - but eventually found out what the problem was (though now cannot find how I did it!).  I found that on the Chiclet Slicer, the date was being formatted using the * asterisk marked dd/mm/yyyy hh:mm date formatting that should recognise the locale on the device.   When I changed it to specifically use this format, the date worked.  But my locale is definitely English UK everywhere, including the BI model.  So I can mark this as resolved - but think there is a flaw somewhere in the slicer formatting!

    • v-henryk-mstf's avatar
      v-henryk-mstf
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi SusieN ，

       

      I agree with you. For the proposed slicer defect, you can post your idea here: Ideas - Microsoft Power BI Community

       

      If there are a lot of people who vote for this issue, Microsoft will officially consider fixing this feature in the next update. Thank you for your feedback.🙂


      Best Regards,
      Henry

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