How to sort the small multiple' Axis by using a calculated measure.

[VincentLai]

Basically i have created a clustered bar chart as below "Product VS Sales Rate", and the sorting for the bar is arranging nicely with desending order.

Unfortunately when i try to apply the "small multiple" with countries column then the bar is no longer sorted nicely as per the above chart.

  

I have tried to sort the axis, however it is limited and only allow to sort with the "Product" value but not the "Sales Rate".

So my goal is to achieve that the bar in the small multiple chart able to sort according to "Sales Rate" in descending order, as per the 1st picture. 

Kindly share to me if there is another visual could acheive this and with the similar look and feel. 

 

[v-yiruan-msft]

Hi @VincentLai ,

Base on my research, there is no suitable visual which can fulfill your requirement. Please review the following thread and check if its solution can help you get it.

Clustered Bar Chart Sorting

Best Regards

[VincentLai]

Hi Rena,

The proposed solution seems to be not applicable to me. 

basically you were created a calculated column that filled with the ranking value, then you assigned this the customer's "Sort by Column".

Your proposed calculated column is actually populating with fixed value, However the value to display in my chart is actually generating on the fly, hence i should generate a calculated measure. 

Unfortunately, currently it only allow to assign "Sort by Column" but unable to "Sort by Measure".

Please correct if am wrong, looking forward to your reply. thanks !!!