cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
po Member
Member

Sort column on matrix - not allowing descending sort on column

Hi,

Have the following issue.

We have a large matrix with % measure with value for each week column and plant name in the rows.

 

When look to try and sort in descending week order the availabel columns to sort on don't show week.

 

Also even when go to modelling and explitctly put sort descedning on the week column when put week in a visual like matrxi it is sorting in ascending order.

 

We wish to sort in descedning order as when users try and send the power bi doc to pdf or powerpoint to print they don't see all the weeks as these are scrollabel due to sheer amount of data.

 

Please see screenshots below.

 

column_sort.JPG

 

week below going horizontally.

 

 

 

 

 

 

screenshot_sort_col_not_available.JPG

 

Any thoughts on how best to resolve to show weeks in most recent order horizontally?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
TijnOnline Regular Visitor
Regular Visitor

Re: Sort column on matrix - not allowing descending sort on column

A true feature to sort horizontally is missing, but there is a valid workaround - a bit spartan though.. 

 

1. Create a new calculated column where you switch your rows to an alphabetic or numeric sorted equivalent. 

Order = SWITCH(Table1[Week], 52, 1, 51, 2, 50, 3.. etc)

2. Follow this: 

Sort by column 

View solution in original post

2 REPLIES 2
TijnOnline Regular Visitor
Regular Visitor

Re: Sort column on matrix - not allowing descending sort on column

A true feature to sort horizontally is missing, but there is a valid workaround - a bit spartan though.. 

 

1. Create a new calculated column where you switch your rows to an alphabetic or numeric sorted equivalent. 

Order = SWITCH(Table1[Week], 52, 1, 51, 2, 50, 3.. etc)

2. Follow this: 

Sort by column 

View solution in original post

po Member
Member

Re: Sort column on matrix - not allowing descending sort on column

Thanks for suggestion.

 

Tried this and realised had to sort the week column by the other column rather than place a direct sort on the column and now looks to work as expected.

 

I would have hoped explitly going into modelling to sort the week in descending order for the column directly would have meant anytime column was used in a visual would display it in descending week order but doesn't.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 226 members 2,365 guests
Please welcome our newest community members: