Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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
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.
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
the blank row should come before total but all other items should not be disturbed. I hope this will makes you understand.
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
User | Count |
---|---|
77 | |
70 | |
69 | |
54 | |
48 |
User | Count |
---|---|
42 | |
37 | |
34 | |
31 | |
28 |