1) I am not completely sure I follow, are you using this
as your second dimension Quarter-Year? or is this a set analysis used in your expression?
2) What is the relation of color and this expression? I am not sure I understand that, can you may be share a sample and demonstrate the issue to us?
I've attached my report.
My main concern is getting the chart to maintain the colors by expression for the [Summary Business Unit] in the charts.
Whenever I make a selection, it loses the colors, with the exception of when selecting the max month within a quarter.
Each chart in the attached report has a different way of keeping the range of 4 quarters, with the exception of the third one, which uses the value of the fields based on the month selected ([1 Qtr Back],[2 Qtrs Back],[3 Qtrs Back]).
The table represents the quarters that should be used based on the month selected.
Thank you for taking some time to look at this.