Treemap Color Consistency Problem with Limited Dimensions

[oseias]

I would like to maintain gradient coloring based on the measure in my treemap, even when limiting the number of dimension values. However, the 'Other' block (which aggregates the excess data) appears in gray, breaking the color consistency. Is there a way to apply the same gradient to the 'Other' block as well?

[robert_mika · Accepted solution]

Try:

Aggregate the “Other” values manually into a new dimension label (e.g., 'Other (' & Count(...) & ')').

This lets you assign a color expression to the “Other” block just like any other value.

Example:

 
=If(Rank(Sum(Sales)) <= 10, ProductName, 'Other')
Then use a color expression like:

If(ProductName = 'Other', ColorMix1(...), ColorMix1(...))