Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RANKX ORDER

Hi All,

I'm using ribbon chart to view the ranking by region. However, what I want to achieve is to view it in ascending order from 1-6 instead of 6-1. 

Dax : 

Rank Region = RANKX(ALLSELECTED(Survey[Criteria]), [Count Region],,ASC)

 

 

 

Need Help

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    Anonymous click on the top right corner of the visual (3 dots) and change the sorting order.

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      parry2k , I did that already but nothing happened.

       

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi  Anonymous ,

         

        After checking,Robbin chart can only sort via X axis ,it cant be sorted by Y axis.

        Below is an example:

        You will find that the month ordering is changed by the sorting selection.

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my raeply as a solution!