I have a report that shows a bar for each session of fitness testing at my school. For each school year, there are 4 testing sessions. I am wanting to use the green color pallet so that the most recent session is dark green and the older sessions are a more faded color. This works great, until a new season starts and my data is refreshed. the new season ends up with an odd color assigned. (possible from the "automatic" pallet. Is there a way for Tableau to automatically reapply the green pallet when a new testing session enters the dataset?
The attached screenshot shows the pallet that was assigned at the end of the 11-12 school year. All sessions after 11-12 have odd colors auto assigned.