Forum Discussion

sarjensystems1's avatar
sarjensystems1
Icon for Helper III rankHelper III
7 years ago
Solved

Matrix 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...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    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.

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

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.

sarjensystems1's avatar
sarjensystems1
Icon for Helper III rankHelper III
7 years ago

HII 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's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion
    7 years ago
    sarjensystems1 Please select “Sort descending” option when you click on the ellipse (three little dots on top right of the visual)