Sorting in a chart

[AEliza]

Hello!

I was wondering if there is way to sort the grouping dimension based on the Measures displayed on a visualization. Let's say, I have a Column chart with Region as grouping dimension and This Year Sales and Last Year Sales as Measures. When the dashboard is viewed, is it possible for Region to be sorted based on the Measure I highlight? 

Thanks.

[shashidhar_sris · Accepted solution]

Hi Aeliza,

Yes. It is possible. Find the below details for your reference.

1) Added Region column in dimension pill.

2) Added sales & Profit columns as measure pills.

3) Used/applied those two measures in sort by under grouping dimension i.e Region

Please let me know if any more information needed.

[AEliza]

Thank you! I do have formula columns as measure, but I am sure I can now make that to work.