Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Matrix Chart - Date Column Order



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?

Community Support
Community Support



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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you @Vvelarde


Just did @v-chuncz-msft, thanks!

Community Champion
Community Champion



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


Lima - Peru

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors