Dynamically position column in matrix based on Total of column

[Alex_G7]

Hi everybody,

Example of table I have 

Location	Orders	InCharge
Dublin	3	Store
Dublin	4	Client
Dublin	1	Factory
London	4	Driver
London	1	Office
Line	1	Driver
Line	1	Client
Line	23	Line
Berlin	6	Store
Berlin	32	Others
Berlin	11	Billing
Berlin	8	Driver
Berlin	55	Client
Berlin	13	Office
Berlin	1	Dockers
Berlin	2	Line
Berlin	54	Factory
Madrid	10	Store
Madrid	4	Others
Madrid	1	Billing
Madrid	7	Driver
Madrid	202	Client
Madrid	6	Office
Madrid	1	Dockers
Madrid	1	Line
Madrid	73	Factory

Matrix created 

   Based on Totals of columns I need reorder   from left to right   how columns displaied in matrix.

   Column with max total on left and so on  

   it should  be 

   Client |Factoty|Others|Line|Driver| Office|Store|Billing ...

Thank for any suggestions

[v-deddai1-msft · Accepted solution]

Hi @Alex_G7 ,

You can try to create a new calculated table and use the [Incharge] column in it :

Summarytable = SUMMARIZE('Table','Table'[InCharge],"total",SUM('Table'[Orders]))

Sort the Incharge column by the total column:

Create new measure for the values:

Measure = CALCULATE(SUM('Table'[Orders]),TREATAS(VALUES(Summarytable[InCharge]),'Table'[InCharge]))

Use the incharge from the summarytable:

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

Best Regards,

Dedmon Dai

[amitchandak]

@Alex_G7 , I doubt there is an option for that. You check and vote or suggest a new idea https://ideas.powerbi.com/ideas/