How do I sort a matrix based on a column

[Breen]

Hello, I am trying to replicate this Tableau table in PowerBI: 

I'm almost there, but I'm struggling to get that ascending sort, broken down by 2021, working.

I've already tried to 'sort by column' using Year, but I receive the error: 

So I'm out of ideas, can anyone help?

[uzuntasgokberk]

Hello @Breen,

Add Column as year in your PowerQuery as number format. Close & Apply.

And select your one required column and sort by column that you added column on power query side.

İf you added a column on dax(new column) that doesn't make sort by columns(Not all columns but some referance columns)

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

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

[Breen]

Hi, thanks for your comment.

Unfortunately, the 'application year string' column can contain the year '2020a', which is going to prevent me from using the number format. What else would you suggest? 

[ryan_mayu]

@Breen 

you can check in the data, if there two columns are one to one relationship. If one value in the column has different corresponding values. Then you can not do the sort by and will get the error message.

[Breen]

Hi, looks like you're right. How could I resolve this?

It's worth me mentioning that 'application year string' can hold strings like '2020a'.

[ryan_mayu]

then you have to clean the data and change 2020a to 2020.

Maybe you can provide some sample data, let's see how we can clean your data automatically.