Forum Discussion
Matrix, sort column by date, index not working for 1 section
in this screen shot, i need 1st Q to show months as secondary layer, months should be sorted by my index which is table, only the 1st Quarter not sorted properly, rest of quarters are good. thi...
i just answered my own question, the month order is sorted automatically by calendar, because month display is from date hieracy-month in calendar table., solution is to display the year hieracy as well- although this will add more subtotal on columns, but that is another question.
amitchandak
Super User
Super UserAnonymous , I doubt the Sort column is saved correctly. Please check that.
sort column index table has been saved corrected and refreshed to PBI report. anything else you suggest me checking?