I have below bar chart :-
I have multiple dimensions and two measures. User want to see the bar values in descending order and it should be applicable whenever user is changing dimension from drop down.
Right now, i have two measure 12RM Current Year and 12 RM Previous Year. I have selected the measure 12RM previous year as the first option in sorting tab:-
Hence it is sorting on first measure, as a result the blue bar of that measure is showing numbers in correct order.
How can I achieve the sorting behavior for both the measure and it should be applicable on all the dimensions?
Please help !