Sorting Row Header According to Date

Question

Hi!&nbsp;I have in my report a matrix table showing the "Employee Name" as Rows and "Type of Expense" as Columns.This needs to be sorted in a descending order to know the top employees incurring expenses so I clicked the "Total" column to be sorted accordingly.&nbsp;However, our boss asked us if it's possible as well to sort the months starting January. Is this possible? If I have to assign numerical values with the months (Ex. 1 as January, 2 as February and so on...), how will this work?&nbsp;Hope you can help me!&nbsp;&nbsp;Thank youDK&nbsp;

anonymous · Answer

Yes, you were right.Add a column with a numeric index to you months (so jan is 1, feb is 2 etc). Then in Table view click on your column, go to Modeling and click on "Sort on column" (not sure how it's in English, somewhat similar to this). Then choose the column with numbers.

newgirl · Answer

Hi!&nbsp;I tried to do your steps. I added a new column and used =MONTH to get the numerical value for the date. I tried to insert this new column in the Rows but now the numbers are all being repeated.&nbsp;Also, if I click the matrix and try to click the "Sort by Column", it's greyed out.&nbsp;Do you other ideas?&nbsp;

anonymous · Answer

No, you don't have to do it in the visual but in the table view.&nbsp;

newgirl · Answer

Hi!&nbsp;I read again your initial response. I opened the Data view, and added a new column representing 1 = Jan, 2 = Feb, and so on.... I sorted this column under Modelling Tab.&nbsp;Going back to the Report view, I replaced the "Months" column with the new column.However, this new column is still not being ordered in an ascending order.&nbsp;Hope you have other ideas!&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Two things- your data is clearly still sorted on the amount, so clicks on the three dots and sort on monthBUT ALSO- you don't have to use now the "number of month" column, just keep the original Month (Jan, Feb etc.)

Forum Discussion

Sorting Row Header According to Date

5 Replies

Related content

Trying to sort column headers

Sorting

PBI Sort Week according

Header sort in Matrix visual

Table Sort , sort order , comparer