Forum Discussion
Solved
Sort Matrix by field which is not in the Matrix (Income Statement)
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 yo...
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
Mmm... that's strange. It definitely worked for me.
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.
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.
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
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!