Sort Matrix by field which is not in the Matrix (Income Statement)

[michellepace]

Hi there, I'd like to sort my matrix rows by a (non-calculated) field, namely FinCode. But I don't want to display this field in my matrix.  Is there a way to do this?

@Anonymousincluding you too in case you also still need an answer.

Regards,
Michelle

[v-yuta-msft]

@michellepace ,

I'm afraid this couldn't be achieved, you need to add the column to the matrix and click ellipse, then select "Sort By".

 

Community Support Team _ Jimmy Tao

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

[michellepace]

Mmm... that's strange. It definitely worked for me.

[freder1ck]

Hi Michelle,
Have you tried setting Fin Descr to sort by Fin Code? In data view, go to the modeling tab. Click Fin Discr column and then the sort by button. Sort it by Fin Code. Then you can sort by description and it will sort as you prefer.

[michellepace · Accepted solution]

Hi @freder1ck - yes that's for sure the answer (and elegantly put I must say!). As a newbie though (which I am) I still had to figure it out step by step. 

Here is a quick video showing the solution: https://youtu.be/n7VYW-vfCrY

[freder1ck]

Wow! Newbie or not, welcome to the Power BI community. Not only did you state your question with the necessary details, you also shared a video of applying the solution. Fantastic! Incredible! Amazing!