Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
My Order Date is not in order. What should I do to format it?
I also tried sort by column, but it is inactive mood.
Hope you could help!
Thanks and hope to hear from you!!
Solved! Go to Solution.
What you showed in the images cannot possibly be datetime, you have an underscore in the value...
If the dataformat is either numeric or date/datetime, it should sort itself.
If it's text you need to sort it by a different column which means you need to get the "sort by column" functionality to work!
/ J
The sort by column usually acts abit strange, usually i have to highlight the column more than once. Try around and see if you can get it out of the inactive mode.
Otherwise you could convert your year/month to numeric,
201901
201902
201903
...
etc
These should order themselves correctly automatically.
Hi,
Thank you for your reply,
Is there any solution that I dont have to change my datetime value to numeric?
cause I need this one for other dashboard by using datetime value.
What you showed in the images cannot possibly be datetime, you have an underscore in the value...
If the dataformat is either numeric or date/datetime, it should sort itself.
If it's text you need to sort it by a different column which means you need to get the "sort by column" functionality to work!
/ J
Hi,
it works now 🙂 thanks for solution and support
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |