Forum Discussion

Anonymous

Not applicable

6 years ago

Sort Column data in reverse order in Matrix visual

Hello, I have the Sales Date in Column section in Matrix visual. I would like to display the recent year to the left (2019, 2018, 2018,...). The dates are in one column and drill-down to Quarter and...

Anonymous

Not applicable

6 years ago

v-lili6-msft Thank you for your response. Yes, I have the 'SalesDate' field only in Columns section. Could you please provide me the example of creating reverse order index column of a column?

Thanks!

Community Support

6 years ago

hi, Anonymous

You could try these steps:

Step1:

Add a year column in edit queries for [SalesDate],(You could add quarter, Month, and Day column in there too)

Step2:

Then create a reverse order index column for Year column, the simplest way is to create a custom as blow:

-[Year]

Step3:

Then create a matrix use these field instead of [SalesDate] as below:

Step5:

Now selected [Year] filed then click Modeling-Sort->Sort by column->choose [Index]

Result:

and here is sample pbix file, please try it.

Regards,

Lin

Sort Column data in reverse order in Matrix visual.pbix57 KB