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.
Additionally, you can also replace the value through the Settings icon, which will be displayed above, for all the measure and dimension columns.
Save the data source; the changes will be updated in the dashboard.
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.
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.
The following steps explain how to replace values using the add rule option:
After applying changes, save the data source. The changes will be updated in the dashboard as follows.
The match case option will be case sensitive, allowing you to replace specific values in a column based on a matching condition.
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.
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.
Enable the match entire string option.
After updating the rule, click the Apply button.
After saving the datasource, the changes will be reflected in the dashboard.
The Edit and Delete options can also be used to update values in the rule.
NOTE: This feature is applicable to only string columns in the datasource.