How to Utilize Conditional Formatting to Show Text instead of an Icon in Bold BI Grid Widget?

Published:

In Bold BI, you can apply conditional formatting to add text instead of an icon in a grid widget. This can be achieved by utilizing an expression. Conditional formatting is a useful feature that allows you to visually represent data in a grid widget based on specific conditions. In this KB, we will explain you through the steps to apply conditional formatting to display text in a grid widget based on predefined conditions.

Step 1: Create an Expression Condition

First, you need to create an expression condition. Here’s an example of an expression you can use:

Expression: IF([ColumnField]<=25,'LOW',IF([ColumnField]&gt;25 AND [ColumnField]&lt;50,'MEDIUM','HIGH'))

This expression will return ‘Low’ if the Mark is less than or equal to 25, ‘MID’ if the Mark is greater than 25 and less than 50, and ‘HIGH’ if the Mark is 50 or above. You can create an expression according to your need by following the above expression.

Step 2: Configure the Expression Field to the Grid Widget

Next, you need to configure the expression field to the grid widget. This will allow the grid widget to use the expression you’ve created.

Step 3: Apply the Conditional Formatting

You need to apply the conditional formatting based on the text condition type. You can choose from the following condition types:

Startswith
Endswith
Contains
Not Contains
Equals
Not Equals

After applying the conditional formatting, the grid widget will be rendered as per your expectation.

Step 4: View the Rendered Grid Widget

Finally, With the expression condition and conditional formatting applied, the grid widget in your dashboard will now display text instead of icons, based on the conditions you defined. You can see the rendered grid widget according to your expectations