Forum Discussion

ChristianE's avatar
ChristianE
Frequent Visitor
6 years ago

Date in data problem

Hi all

 

My date settings are "ddmmyyyy", but for some reason whenever im trying to filter a datacolumn (using the option date "filters -> After ") that specific menu is "mmddyyyy"


Is there any way to change this or is it a bug?

Need Help

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi ChristianE 

    there is a difference between format that data dispalyed to user and locale date format

    as I understand you set displayed format (possible in Modelling ribbon) as "ddmmyyyy", but its still "mmddyyyy" format as your system localization. So, built-in filter uses system format 

    anyway try to change language in File-Options-Regional Settings

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • ChristianE's avatar
      ChristianE
      Frequent Visitor
      6 years ago

      Hi az38 

       

      I haven't changed any settings, they are at "Danish" (which uses "ddmmyyyy"), and it works fine everywhere except when i try to filter a table under the "data" panel (where it only accepts "mmddyyyy").

       

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        6 years ago

        Hi ChristianE 

        As tested with this kind of setting, 

        My server->Setting->Time&Language

        Power BI->Files->Options and Setting->Regional Settings

         

        The format of date column is correct in both data model view and power query view filter.

        Please check your setting, if you have any probelm, feel free to let me know.

         

        Best Regards
        Maggie
        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.