I am having to measure in bar chart order placed and order received in Fiscal year and I also have a filter pane which shows last 5 year data last 10 years etc
Now I want to color min order received and Min order placed in the Fiscal year as red and max order received and placed as green bars
But when I am clicking on a filter like last 5 years it is not giving green or red color so what expression should I give in the colour of the bar chart
so what to do that whenever i click on the filter it will color min max for years under that filter