Colors are not reflecting with Year in Cyclic drill down for YoY comparison
Need your help in solving an issue.
I need a YoY graph, along with Category and Product in one chart. So used a cyclic flip option for Category and Product .
Also defined color codes for them.
Below is the Issue:
I used max(year) for current Year and Max(Year)-1 for Previous Year in expression, when nothing is selected in year it is working as expected . But when we select the year then the defined color codes are reflecting for selected year(Max (Year)) only and not for previous Year.