Forum Discussion

Universe24's avatar
Universe24
Frequent Visitor
3 years ago

How to change Row sequence in the matrix

Hello Experts,

 

I have a matrix table with rows as below in table 1, but i want to rearrange sequence as table 2. Is there anyway we can do it.

 

Table 1 Table 2
201 - salary 270 - overtime
270 - overtime 322- Temps
276 - social 281 workers pay
322- Temps 201 - salary
342 cross chargers 276 - social
281 workers pay 342 cross chargers

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Universe24 You can add a column in Power Query Editor that creates a numeric sort order column and then in the Data view in Power BI Desktop you can set the Sort By column.