sort each metric (column) separately
I have a simple vertical column chart, with few metrics for example: A,B,C.
I enabled the option in the chart settings to enable visible series selection so now I can choose which metric to see in the chart. I would like all metrics to be sorted desc from highest value to the lowest but the only thing I can do is to sort one metric in the data view so for example only when I look at metric A I see it sorted, when I look at metric B or C they are not sorted.
is there a way to achieve this?
I am trying to avoid creating a seperated bar chart for each metric (in theory I can make a sperated report based on metric A,B or C and the problem is solved but I can have a lot of metrics so it is not the best solution)