Matrix Chart - Date Column Order

[lyasolis]

Hi,

I have a Matrix Chart with the following columns:

UserID |  January 2017  | February 2017  | March 2017 | etc... | Total

The values in the month columns are the amount spent by user that month.

I would like the columns to be in the following order:

UserID | Total |  March 2017 |  February 2017  |  January 2017  | etc..

I can't find the way to order the dates in reverse, with most recent month first.

Thank you in advance!

PS just had an idea of adding a column and indexing the dates in the order I want them - would that be considered a good practice?

[v-chuncz-msft]

@lyasolis,

As for the Total column, you may vote up the idea below.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19103272-table-matrix-total-colum...

[lyasolis]

Thank you @Vvelarde

Just did @v-chuncz-msft, thanks!

[Vvelarde]

@lyasolis

hi, like you say add a order column in the month calendar in reverse way.