I have a chart with an expression for each month. My sort order is January, then February, then March, etc. When I select a month (say October) I have a condition that hides any month that is not equal to the selection. However the sort order is still based on January.
Is there a way, in my example above, to keep the sort order by month, but when I select on October it sorts on October, then when I deselect October it goes back to sorting by Jan, then Feb, then March, etc.?