Replace Value Support in Column Level

You can modify the specific column values in the datasource that contain null and blank by using the replace value support at the column level.

Settings icon

Additionally, you can also replace the value through the Settings icon, which will be displayed above, for all the measure and dimension columns.

Null replace value in column

Save the data source; the changes will be updated in the dashboard.

Null replace value output

The column replace value takes precedence when we use both the data source level and the column level replace value. By using the same columns in the dashboard, you can see the replace value changes reflected in the dashboard as follows.

Column level support output

Configuring the Replace Value in Column by Add rule option

The addition of the rule feature in the replace value support allows you to modify any values in any column from the datasource, as well as customize null and blank values.

Add rule

The following steps explain how to replace values using the add rule option:

Click on the Add Rule option. The edit dialog will open, as shown.

Edit Rule

After customizing the value to find and the value to replace, click the Add Rule button.

Custom Rule

After updating the rule, click the Apply button.

After applying changes, save the data source. The changes will be updated in the dashboard as follows.

Save button

Replace the value based on matching case

The match case option will be case sensitive, allowing you to replace specific values in a column based on a matching condition.

Match case

To enable the match case option, update the add rule and click the Apply button. After saving the datasource, the changes will be updated in the dashboard.

Match case value

Replace the value based on Match entire String

Enable the match entire string option. This means that the replacement will only occur if the entire string in the target column matches the specified value.

Match entire string