Forum Discussion
Solved
Sort visual by year and month
Hi, I am struggling this for some time, and if it comes right it is par azar.
I want to sort the income month by month by the year and the month.
On the left table, I filtered to show only 0ne year, somehow it sorted it by month too.
I copied the table to the right it was sorted properly but 2019 first. As I sort it by year the visual is sorted by month alphabetically.
What is the trick?
Giora
5 Replies
- Are you using a date table? If not, that would do the trick with regard to the sorting by year, and then by month within that year.
If this answered your question, please mark this as the solution. Kudos are welcomed!My apologies, I didn't noticed in the opening post. In the dataview, you can select the MonthName column and pick the menu option 'Sort by' column. Then chose a column that is numbered, or for example YYMM (which would also do the trick I think).
Did that solve your problem?
