Forum Discussion

locle90's avatar
locle90
Icon for Helper I rankHelper I
5 years ago
Solved

Sort 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
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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.

     

    Here is the sample pbix file.

     

    Best Regards,
    Henry

     

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

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
5 years ago

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.

 

Here is the sample pbix file.

 

Best Regards,
Henry

 

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