Forum Discussion
gtamir
6 years agoPost Patron
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...
- 6 years ago
You may take a look at the posts below.
JarroVGIT
6 years agoResident Rockstar
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!
If this answered your question, please mark this as the solution. Kudos are welcomed!
- gtamir6 years agoPost Patron
JarroVGIT Yes. you can see in the attached image the columns and measures involved.
- JarroVGIT6 years agoResident Rockstar
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?
- gtamir6 years agoPost Patron
I am not sure I understand you, but here it will sort alphabetically.