Forum Discussion
Post ProdigySorting date in Power BI
Hello,
How I could sort date in power BI? Because I see February, then January, July before June. Here is a picture of silcer.
Here 6 week and february goes before juanary that is not correct, so how make ascending sorting? Year, week, month, day.
Hi Analitika ,
Is this you want?
If yes, please sort it by Month
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- jdbuchanan71
Super User
You would need to add a sorting column to the table where that data is coming from. For months you can add something like.
Month Sort = MONTH ( YourTable[Date Field] )Then you set the sort order on the [Month Name] column to sort by the values in the [Month Sort] column. Here is a post where setting the sort order is described.
- v-chenwuz-msft
Community Support
Hi Analitika ,
Is this you want?
If yes, please sort it by Month
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
