Can someone help me sort the expression named "instances" in this case in descending order for every month in a chart. There are 2 Dimensions namely "Month" & "Configuration Color".
Attaching the test qvw file + test table file
Brilliant. I just tried with this as a calculated dimension (similar to Marco's response) and it worked like a charm. I am amazed how you guyz make it so simple
=Dual([Configuration Color], Aggr(instances, Month, [Configuration Color]))
Yeah, but one remaining issue is that the color legend and the colors are now showing distinct values per combination of Month and Configuration Color. Marco solved this by using a custom coloring and a separate color legend chart instead of using the bar chart's one.
It would be nice if QV would offer a more simple way of changing the sort order in a stacked bar chart.
For example, it's quite easy to create the correct sort order in a straight table chart.