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

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
Icon for Microsoft Employee rankMicrosoft 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 🤔