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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
learner03
Post Partisan
Post Partisan

Sorting in Matrix-custom column for sort

I have Matrix Visual and want to sort the coloumns by below critieria-

first, if Impact is Yes , then it should come at the top, then by Date 1 then Date 2and then Date 3 in Ascending order-

INPUT-

akapoor03_0-1685338855536.png

@Greg_Deckler 

 

7 REPLIES 7
Ashish_Mathur
Super User
Super User

Hi,

In the matrix visual, click on the Impact column, hold the Shift key and click on the Date column and so on.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur Tried this, but the Blanks in date column are coming at the very top.

Hi,

Expand the filter pane and filter out the blanks from each of the Date columns.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur I need the blanks as well in the date coloumn as there are more additional columns in the report that has data to be displayed.

Hi,

When you click on the heading a second time, then the sort order changes.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
miTutorials
Super User
Super User

I'm afraid there is no easy way to do this.. The below alternative solution should help.

 

How to Custom Sort Multiple Columns in Power BI | MiTutorials - YouTube

@miTutorials thanks, but couln't get how to work with dates here

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.