Forum Discussion
sarjensystems1
Helper III
Helper IIIMatrix visual
Hii I have the requirement like to show the forecast dynamically for 12 months i.e from AUG 2019 to sep 2018 I have taken the matrix visual and used month-year in the columns field and countries in...
sarjensystems1 Please create a new SortKey column for your MonthYear column
SortKey_MonthYear = FORMAT([date],"YYYYMM")
So the values will be 201908,201907,201906 etc... Use this sortkey column as Sort By Column for the MonthYear column. Then the ascending or descending on your Sort By option in Matrix visual will work as expected.
sarjensystems1Helper III
Helper IIIHII PattemManohar
After creating the sort colmn it is sorting in the ascending order(SEPT2018,OCT2018,NOV2018...........JULY2019,AUG2019)
.but i need descending order(AUG2019,JUL2019......NOV2018,OCT2018,SEP2018)
Thank you
PattemManohar
Community Champion
Community Championsarjensystems1 Please select “Sort descending” option when you click on the ellipse (three little dots on top right of the visual)