Dynamic ordering of a matrix column based on slicer selection

[Nyakwezi]

Hi all,

Does anyone know how to dynamically order the columns in a matrix table?\

e.g.

I have a disconnected customer slicer which I use to select a specific customer and highlight their column (as seen in the picture below) 

I would like to be able to order the matrix table so that the customer selected appears first in the matrix table and all the other customers appear after

[Nyakwezi]

thanks @amitchandak 
For the C1 Sort switch statement - I have about 1000 customers.

For the example I showed, customer F  was selected in the slicer and therefore I needed Customer F to appear first but there is a scenario where Customer 1000 might be selected in the slicer.

[amitchandak]

@Nyakwezi , Create two new columns in your table. Assume field on column matrix is C1

C1 New  = [C1]

C1 Sort = Switch([C1],

"F",1,

"A",2,

"B",3,

"C",4,

"D", "5",

10)

and mark C1 Sort as sort of C1 New and Use C1 new in visual . C1 new is created to avoid circular reference

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