Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to Sort Columns in matrix visual?

Below is the screenshot where left part is the data, and right part is the result.

I need to sort the columns descending (i.e Budget 2018 , 201801, 201802, 201803)

The visual used here is the matrix. (pivot table)

 

I have tried sorting with the index column, but still not able to get accurate result.

 

Any help is appreciated, 

Thanks in advance !!

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous ,

     

    Change the Index of "Budget 2018" from 4 to 0.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks v-chuncz-msft!! ,

      It worked, but this is quick fix.

      What if I receive data for "2020" and "budget 2020" again I need to put indexing and change the index manually.