Forum Discussion

sarjensystems1's avatar
sarjensystems1
Helper 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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi sarjensystems1 ,

 

If you select the modeling tab and then your month-year field from the fields pane, you should see the option to sort by a column. You should then be able to sort by your primary date field, which will make sure it stays in order when being put into the matrix visual.