Forum Discussion

AnkitaaMishra's avatar
AnkitaaMishra
Super User
11 months ago
Solved

Treemap conditional formatting help

Hi All,

I’m trying to apply conditional formatting on a Treemap visual in Power BI.
The requirement is to have two different color palettes applied dynamically based on the number of departments shown in the visual. Currently, I’m using the gradient option, where I can only define a single min → max color range.

 



However, I need the first half of the departments to follow one palette (e.g., Purple: #D0AAF0 → #2C0440) and the second half to follow another palette (e.g., Blue: #E1EBFF → #00297A).

Since the number of departments can grow (e.g., 20 today, 40 tomorrow), the logic should remain dynamic.

Is there any workaround or approach to achieve this in a single Treemap visual?

2 Replies