topic Re: Sorting in a chart in Dashboards & Analytics Discussions

Sorting in a chart

AEliza — Fri, 07 Apr 2023 14:59:32 GMT

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.

Re: Sorting in a chart

Shashidhar — Tue, 11 Apr 2023 09:20:40 GMT

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.

Re: Sorting in a chart

AEliza — Mon, 17 Apr 2023 20:31:25 GMT

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