Column Sort by column function not working for matrix

[Anonymous]

Hi, 
I have a column month which is sorted by another column month no.
The sorting working for other visuals but in metrix visual the sort is not working

is there any option to fix this sorting

[v-xiaotang]

Hi @Anonymous 

Hope you are doing well.

Have you solved this question? If you have solved the question, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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

[v-xiaotang]

Hi @Anonymous 

"I have a column month which is sorted by another column month no."

What's the type of another column?

Best Regards,

Community Support Team _Tang

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

[Anonymous]

@v-xiaotang The type of another column is Whole number

[v-xiaotang]

Hi @Anonymous 

Thanks for your reply.

If the type is Whole number, it should work fine. Could you share a sample file for us to check? Thanks

Best Regards,

Community Support Team _Tang

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

[Anonymous · Accepted solution]

Yes, I check this again the column sort is working properly. The issue in the upper screen shot was beacuse or additional sorting applied on measure value.

[Anonymous]

@amitchandak I checked this and everything looks good

I think the problem is with metrix visual

[amitchandak]

@Anonymous , check do you have two values for same month in sort column, I doubt that

to test plot both to them unsummarized in a table visual and sort on month and check

This is how you column and sort column should look like

Month Year = FORMAT([Date],"mmmm")
Month Year sort = month([DAte])