Forum Discussion
Helper ISort by day on report
Dear All,
I tried to make report for sales status on last 1 month.But i can not sort by day like picture bellow.
Please help to give me advice.
I want to sort to 16-30
Hi locle90 ,
As you show the pictures, you want to sort them by Date. You need to check the type of your Date column. I did the following test: if it is a Test type, after using sort, it will not be sorted by Date, it will be sorted by quantity. Only columns of type Date/time can be sorted correctly.
Best Regards,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
locle90 , you need to create a sort column
Sort MMDD = format([Date],"MMDD")
make this as sort column of your month
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
v-henryk-mstfCommunity Support
Hi locle90 ,
As you show the pictures, you want to sort them by Date. You need to check the type of your Date column. I did the following test: if it is a Test type, after using sort, it will not be sorted by Date, it will be sorted by quantity. Only columns of type Date/time can be sorted correctly.
Best Regards,
HenryIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
