I have the date on the color shelf. When I created the dashboard I put all dates as blue with the highest date the darkest color so it would stand out. The problem is when the data source refreshes the dates change and the color scheme reverts to an assortment. Is there anyway to automatically assign colors in a more intelligent way? In an ideal world I would make the max date a certain color (red) with the remainders on the blue gradient.