Revise the order of header in PowerBI

[pang22]

Hello,

How to change the order of the red and blue one in PowerBI?

That is Heritage put on the left and Fashion put on the right.

And Order OH put on the left and OPN put on the right. Thanks.

[Anonymous · Accepted solution]

Hi @pang22 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create tables.

Table 2 = DATATABLE ( 
    "Factory", STRING, "Index", INTEGER,
    {
        { "Heritage", 1 },
        { "Fashion", 2 }
    }
)

Table 3 = DATATABLE ( 
    "Type", STRING, "Index", INTEGER,
    {
        { "Order OH", 1 },
        { "Opn", 2 }
    }
)

(3) Select the Factory column of Table2 to sort by index column, and select the Type column of Table3 to sort by index column. Place the Factory column of Table2 and the Type column of Table3 on the matrix visual object.

Best Regards,

Neeko Tang

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

[amitchandak]

@pang22 , for that go and create a sort columns

new columns

Factory 1= [Factory]

Factory sort  = Switch([Factory],

"Heritage",1,

"Fashion",2,

3)

Now mark Factory sort  as sort column of Factory 1 in column tools and use Factory 1 in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[pang22]

@amitchandak Thanks for your reply.

I input the formula and click Factory sort.

Then I put Factory 1 in the columns field. 

But it still show the "Fashion" on the left.

Could you have a check?