Hi - i'm working on a simple dashboard where user will pick a certain date in a multipicker. Once date is being picked it will display data on every panel. My issue is that whenever i picked multiple dates for example:
27-Nov-2020 20-Nov-2020 30-Oct-2020
it will always get to the point that it will display the highest numeric value (30-Oct-2020) despite that I picked the other dates first.
what i am looking for is to display date based on what did i select in the picker regardless of its numeric value and they should get display from right to left
i tried to change the date format in the lookup to see if it won't get sorted automatically but to no avail. it seems that date with the highest numerical values will automatically get sorted ascendingly