Forum Discussion

ZowieS's avatar
ZowieS
Regular Visitor
6 years ago
Solved

Problem with Between Slicer - Date

Hi,   My Goal: I'm trying to get my between slicer with dates working but I'm unseccefull. I would like to slice my visuals based on date. Both Create and Closed date. Something like this: ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    One other thing to try.  Make sure your first Changed Type step for that column sets it to text type, use Column From Examples to get the format you want based on that column selection, and then change to Date.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ZowieS ,

 

Change Locale for import under Options to English (United Kingdom).

Then change the Date type under Column tools to Date/time.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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

  • ZowieS's avatar
    ZowieS
    Regular Visitor
    6 years ago

    Hi Anonymous,

     

    Thanks for your reply!

    I've tested that with both Swedish (Sweden), English (Sweden) and Enligsh (United Kingdom) but it still switch places on the Day and Month 😑

     

     

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      6 years ago

      One other thing to try.  Make sure your first Changed Type step for that column sets it to text type, use Column From Examples to get the format you want based on that column selection, and then change to Date.

       

      If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

      Regards,

      Pat

      • ZowieS's avatar
        ZowieS
        Regular Visitor
        6 years ago

        Hi mahoneypat,

         

        Thank you!

        That worked with "Column From Examples" for some reson 🤔