Colours in geospatial graph

[Mahika_Garg]

When I select all countries, my conditional formatting of colours(gradient) is showing correctly, but If I select only one particular country, it shows brown colour not the one I selected

I want even if I select a particular country, it still shows colours what I selected

How can this be achieved?

[Xclipse]

Hi @Mahika_Garg

To ensure consistent gradient colors even when filtering to one country/state:

• Select the filled map visual.
• Go to Conditional formatting → Background color → Gradient (choose your palette).
• Manually set Min, Mid, and Max to fixed values from your full dataset range.

[Mahika_Garg]

Since it is a daily changing data, I can’t have an fixed values put there for min, max, and mid- it should be auto calculated

I don’t have any fixed range of data from 0 to n

[Xclipse]

Hi @Mahika_Garg

To ensure your filled map maintains consistent gradient colors even when filtering to a single country (instead of showing uniform brown), try this effective workaround.

Gradient interpolates between your fixed values (0, 1 and 2), giving 3 distinct bands. Colors now stay proportional across all filters.

Example:

ifelse(sum(Sales) < 0, 0,
       sum(Sales) <= 50000, 1, 2)

[Mahika_Garg]

Thanks, it worked even when I just put min value to 0