I'm having an issue with colors in a Heatmap. I have created a heatmap with 2 dimensions and 1 measure and used a gradient color scale. The problem I am having is that when looking at the whole dataset the colors look good but when I filter out to look at one field, the colors change. I want the colors to always stay the same and not change no matter what is selected in the Heatmap but I can't seem to figure out how to do this.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Attached is a sample dataset and screenshots of the Heatmap. I'm trying to get each store to maintain it’s own heatmap color instead of the heatmap color changing with added store selections.
