To fix rows or order the rows of matrix table on top

[Jessica_17]

Hello All,

I have a matrix visual like this,

in which for each customer there are some activation which are cosntant throughout due to some measure.

Now the ask is
how can I move the constant values at the top with some value and non constant values according to customer at bottom as is like this:-

Can anyone please help me in this?

and also need to keep Customer "Other" as fixed on top irrespective of Customer slicer value selected, for rest it should work correctly even after Customer slicer value selection.

[Jessica_17]

Thanks @amitchandak 

I had added one more requirement that "Other" needs to be fixed on top irrespective of any slicer value selected, not sure how can we achieve this?

[amitchandak]

@Jessica_17 , In that case, slicer needs to be on an independent/disconnected table,

Then then you filter value in measure or use measure in visual level filter

M1 =

var _val  = union(values(Cust[Customer]), {"Other"} )

return

calculate(sum(Table[Value]), filter(Table, Table[Customer] in _val   ) )

You can also consider treatas - https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[Jessica_17]

Hello @amitchandak 

It tried both Treatas and above measure, it is still filtering out the values on basis of Slicer Selection and not showing the "Other" on top.
Is there any other apporoach, and also if possible can you send me a pbix file too  and also forgot to mention that there is a customer named "Other" too in the list.

[amitchandak]

@Jessica_17 , You have to create a column that has that order in numeric format, prefer power query to avoid circular dependency

In DAX you might need , new columns like

Customer 1 = [Customer]

Customer sort  = if([Customer] = "Other", 0 , Rankx(Table, Table[Customer],,asc, dense) )

Now mark "Customer Sort" as sort column of Customer 1 and use Customer 1 in visual

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