Forum Discussion

ctspradeep's avatar
ctspradeep
Regular Visitor
5 years ago
Solved

Matrix sort order based on second row

Hi,  I am trying to sort matrix second row but it's grouping first row and then sorting. Is there a way to override grouping and sort based on specific rows? Data:  Column Name Period Item V...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ctspradeep ,

     

    My workround is use a measure to "replace" the Column subtotals,

    Please try this:

    Measure =
IF (
    HASONEVALUE ( 'Table'[Item] ),
    SUM ( 'Table'[Value] ),
    MAX ( 'Table'[Percentage] )
)

     The final output is shown below:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ctspradeep ,

 

Actually, I'm not very clear about your issus, did you want to sort by Percentage column not by Name column in matrix ?

 

To my knowledge, sort works based on the ROWS field in matrix, and you could sort by different field via Drill-down like this:

 

Or refer to this thread:

https://community.powerbi.com/t5/Desktop/Sorting-single-value-column-descending-by-latest-week-ending/td-p/1752167

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.