Matrix Sort Column

[HugoJesus]

Hello Everyone, 

I'm facing the follow issue and I don't know how to work around.

I've the following data:

Date	Item	Price
01/01/2021	Car	20
01/01/2021	Bike	10
01/01/2021	Plain	5
02/02/2021	Car	20
02/02/2021	Plain	5
02/02/2021	Bike	10
03/03/2021	Bike	30
03/03/2021	Bike	10

I've used a Matrix Table, but I've tried to sort the column Item with Price but I receive the message saying "You have more than 1 result to the Item".

Using the Matrix, the columns are sorted by alphabetic:

Date	Car	Bike	Plain
01/01/2021	20	10	5
02/02/2021	20	10	5
03/03/2021		40
Total	40	60	10

My idea is sort the Matrix Column Headers by Total Column, like this:

Date	Bike	Car	Plain
01/01/2021	10	20	5
02/02/2021	10	20	5
03/03/2021	40
Total	60	40	10

And if I filtered for 02/02/2021 the order columns have to change like this:

Date	Car	Bike	Plain
02/02/2021	20	10	5
Total	20	10	10

I believe someone here in comunnity have dealed with something like this.

Best Regard's

Hugo Jesus

[HugoJesus]

@v-rongtiep-msft 

It will take too long time, I need something for the moment, any workaround. 😵

[v-rongtiep-msft]

Hi @HugoJesus ,

Now it is not support to sort by changing the original data size in Matrix. If you really need the function, Please create the idea and vote for it.

https://ideas.powerbi.com/ideas/

Best Regards

Community Support Team _ Polly

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

[HugoJesus]

.