Forum Discussion
gtamir
Post Patron
Post PatronSort 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...
JarroVGIT
Resident Rockstar
Resident RockstarAre 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!
gtamirPost Patron
Post PatronJarroVGIT Yes. you can see in the attached image the columns and measures involved.
- JarroVGIT
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?
- gtamir
I am not sure I understand you, but here it will sort alphabetically.
v-chuncz-msftCommunity Support