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.
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 )
Solved! Go to Solution.
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 -
I added link to my dummy file where I wanted to just create calendar table and I did exactly the steps from my original file and it still doesn't work, so you can check it.
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
May the fourth be with you, join us online!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.