Forum Discussion
Helper IVOrder of Columns Matrix Table
Hi
I have a matrix table like below that is split into years then terms. I want it to be ordered so Term 2 is first in the year then Term3 and then Term 1.
I added an order column and then ordered the table by this but it did not work and when I put it in the table it is not the outcome I want as the table gives the order a sub total and buts in an extra column header which does not look correct.
Is there a way to order the table so it reads Term 2 then Term 3 and then Term 1?
many thanks
Hi WJ876400
I believe you can try like this below:
https://community.powerbi.com/t5/Desktop/Move-column-position-in-power-BI-Matrix/m-p/439041
Add the custom column and sort by it.
6 Replies
- MFelix
Super User
Hi WJ876400 ,
Have you use the Sort by other column option? this should sort your information.
Regarding the You can go to the subtotals options and then select Per column level then turn off the level that you need to hide the total column. This option is also available in rows if you have more than 1 level.
WJ876400Hi
sorry, what do you mean sort by other column option, where is that in BI?
thanks
- MFelix
Hi WJ876400
Check the documentation with detailed explanation https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
- amitchandak
If Term 1, Term 2 is measure it is not possible. The way out use measure to dimension conversion. Mean create a table having measures also in rows.
In edit query Unpivot.
- WJ876400
the Term 1 ,2 ,3 is a custom column in the query
thanks
- v-diye-msft
Community Support
Hi WJ876400
I believe you can try like this below:
https://community.powerbi.com/t5/Desktop/Move-column-position-in-power-BI-Matrix/m-p/439041
Add the custom column and sort by it.
