Conditional coloring

Conditional coloring can be used to highlight items in the hierarchy based on measures. It is advised to create an aggregation to use for conditional coloring. Look at the "Aggregation" page in this wiki for more information on how to set that up.

Conditional coloring based on an aggregation on the profit measure might look like the image below, where each negative value is colored pink.

To enable this feature, first go to the "Formatting" tab in the "Options" page in the configuration, where you need to select the column/level you want to apply conditional coloring on.

After setting the level, scroll down to the conditional coloring options.

Here, we already selected the sum aggregation on the SUM(Profit) measure to be used for conditional coloring.

Select an upper and lower bound to dictate what values should be colored. You can click the colored boxes to change the color.

After which you need to select if you want to color the full background of each item or only the text. After clicking submit, the conditional coloring should be visible on the selected level.

Instead of using an upper and lower bound, you can also select equals coloring to only color items that are exactly equal to the inserted string. In this example we used "Inactive".

Latly, you can select the "Gradient" checkbox to color every item from smallest to biggest value on a color gradient.