Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sort Clustered Bar Chart Based on Legend

Hello,

I'm trying to sort a clustered bar chart based on its legend. For each cluster, I have two bars representing values from two periods of time, say time A and time B. Now I'd like to sort the clusters based on the values from time A only. Is this possible without creating new measure/column?

Thanks!

4 Replies

  • Anonymous if you click on 3 dots on the top right corner of the visual, you have sorting options, sort by and ascending/descending? Did you try that?

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  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

      Thanks for your input parry.

      I have tried this method, but it sorts the clusters based on the sum of each cluster.

  • Anonymous I guess there is no option to sort by legend, either by cluster value or by x-axis. Maybe you want to look at custom visual that allows to do sort by legend.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  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.

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support

    Hi,  Anonymous 

    No.Sorting the clustered Bar Charts essentially to sort the fields on the axis.

    And you must create a calculated column to sort the fields on the axis,

     

    Best Regards,
    Community Support Team _ Eason