Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Column Sort by column function not working for matrix

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

 

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

7 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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])

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak I checked this and everything looks good

    I think the problem is with metrix visual

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      v-xiaotang The type of another column is Whole number

       

      • v-xiaotang's avatar
        v-xiaotang
        Community Support
        4 years ago

        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.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    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.