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
Lahari
Helper II
Helper II

sorting a matrix visual descending order based on total but in the item row blank should be at last

Hi Everyone,

 

please help me out for sorting the matrix visual in power bi desktop where the rows are taken from Pick_latest_table, Item column and columns are taken from calendar table - month name column. values from a measure by name count request. now i have to sort the matrix visual in descending order by count request in total but the blank item should be placed at last. please help me out for sorting this in matrix visual. i am attaching the table as well for your reference 

 

 

Lahari_0-1686248857788.png

 

 

Lahari_1-1686248909656.png

 

Thanks in advance and here the blank item total is 4 but we have total with other as  3, 2 and 1 as well but i need total as desceding order but irrespective of the total sorting the item blank should be placed at last row. if it is possible please let me know.

 

Thanks in advance.

 

 

3 REPLIES 3
Lahari
Helper II
Helper II

I have a matrix visual where row is taken from a Pick_Latest_Tickets table which is having a column of Item. columns are taken from the calendar table of month column (jan,feb,......dec) and values are taken from the measure by name count request which is 

Count Request = CALCULATE(DISTINCTCOUNT(Pick_Latest_Tickets[REQUEST_ID]),USERELATIONSHIP(Calnedar[DateID],Pick_Latest_Tickets[DATE_ID]))
 
now i am able to sort the matrix visual by count request by total but here i need the item which is blank should be presented at last row irrespective of the total value. Means - except the Blank item all the totals should be sorted descending by count request total but i need blank at the end of the row.
 
I hope the explaination is clear now. 

Lahari_0-1686252590302.png

the blank row should come before total but all other items should not be disturbed. I hope this will makes you understand. 

nvprasad
Solution Sage
Solution Sage

Hi Lahari,

 

Your question is not clear. Could you please eloborate more along with same sample data?

 

Appreciate a Kudos! ‌‌
If this helps and resolves the issue, please mark it as a Solution! ‌‌

Regards,
N V Durga Prasad

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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