Sort Clustered Bar Chart Based on Legend

[Anonymous]

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!

[v-easonf-msft]

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

[parry2k]

@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.⚡

[parry2k]

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

Thanks for your input parry.

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