Forum Discussion
Sort Months by dates in date table
Hi,
I have my date table sorted by date and in visual my month are not sorted by by the date but by months alphabetically.
I have marked my table as date table too.
My date table:
My two visuals.
I disabled the hidden local date tables and created a hierarchy for above visual.
Does the hierarchy need to be sorted somehow?
Thanks for help.
K.
EDIT:
Calendar =
ADDCOLUMNS (
CALENDAR(DATE(1981;01;01);DATE(2080;12;31));
"CALENDAR YEAR"; YEAR ( [DATE] );
"MONTH NAME"; FORMAT ( [DATE]; "MMMM" );
"MONTH NUMBER"; MONTH ( [DATE] );
"WEEKDAY"; FORMAT ( [DATE]; "DDDD" );
"WEEKDAY NUMBER"; WEEKDAY( [DATE];2 );
"WEEK NUMBER";WEEKNUM( [DATE];21);
"DAY"; DAY([DATE]);
"QUARTER"; "Q" & TRUNC ( ( MONTH ( [DATE] ) - 1 ) / 3 ) + 1
)
EDIT2: File
https://drive.google.com/file/d/1AlsVzHyg0qV6WDkfE3-zf26xBT6oTA9z/view?usp=sharing
The sort column did not save correctly. I did it and it is working.
https://www.dropbox.com/s/ikvk0k3juemuqj9/SortMonthQ.pbix?dl=0
6 Replies
- AnonymousNot applicable
Try sorting the month by the month number under the modeling tab.
- kap_55Frequent Visitor
I tried that before I posted and I does not work for me for some reason. Adding my dax to original post.
- amitchandakSuper User
Sometimes the visual by default sort it on Value. Have you checked it is sorted on the month column?
If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970