Dynamic Sorting after Matrix Col-Row switch and Grouping Questions

[Anonymous]

Hello - 

I have two questions - You can give me a solution requiring C# or DAX! 

1 I have a matrix table where 66 of those frustration variables are now individual rows and the columns are different values of the field Wireless Provider. But now that it's a matrix table and I flipped the rows and columns I can no longer sort based on clicking the column name as there isn't a drop down feature anymore. Chat gpt says to use slicers and a rank col but it wants a single numeric field to rank.... I want all 66 frustration values in desc order and I want to be able to do this for each col or value of wireless provider.

2. I want to group those 66 frustrations to a higher level so you would think I'd be able to do that easily especially since the calculations that make each frustration value are averages that change based on the categorical you pick to cut them by but it's not very straight forward. For our purposes let's say I want frustration 1-10 in Group1 and then every ten another group til the final 6. The order is different IRL but if u tell me how to do thst I'll extrapolate...

[amitchandak]

@Anonymous , In Matrix you can sort on Row field  or Measure/Measure Totals.

Field on the column will sort ascending

to change that, you need to use sort column

Column 1 = [Column]

Column Rank = Rankx(Table, [Column],,desc,dense)

Assume you have the [column] in column field of Matrix. create the above two columns and use Mark Column Rank as sort column of column1 and use column1 in visual (This additional column will avoid circular dependency)

2. For the second you need to create a group of the calculated columns using a switch

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Tableau Vs Power BI- Chapter 23: How to create groups: https://youtu.be/G6-oIdlY_XY

[Anonymous]

I created both columns but when I do exactly what you said I am still getting circular error and I want the ability to sort each of the different values the column takes (which are now seperate column headers in the matrix table).  I need Value1....ValueN to be able to sort asc or desc - I tried adding a slicer with the rank column and the sorts still don't work.  I haven't looked at your second suggestion yet.  Any ideas on the first?  Thanks so much for the reply!