Forum Discussion
Matrix Sort Column
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
3 Replies
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.
Anonymous
It will take too long time, I need something for the moment, any workaround. šµ
