Skip to main content
cancel
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

Reply
lyasolis
Frequent Visitor

Matrix Chart - Date Column Order

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?

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@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...

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!

Vvelarde
Community Champion
Community Champion

@lyasolis

 

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

 




Lima - Peru

Helpful resources

Announcements
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.

PBI_Carousel_NL_June

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