Capitalizing Each Word in Bold BI: A Step-by-Step Guide
In Bold BI, there are multiple ways to capitalize each word in a string column. This can be done at the expression level, data source level, and widget level. Below are the methods to achieve this:
Methods to Capitalize Each Word
1. Using the INITCAP Expression
You can use the INITCAP expression in the Expression Window. This expression converts the first character of each word in a string to uppercase and the remaining characters to lowercase.
2. Data Source Level
Inside the data source, you can capitalize each word by following these steps:
- Navigate to the column settings of the string column.
- Click on the “Show Value As” option.
- Select the “Capitalize Each Word” option.
3. Widget Level
Similarly, at the widget level, you can apply the same capitalization method:
-
Go to the column settings of the string column within the widget.
-
Click on the “Show Value As” option.
-
Choose the “Capitalize Each Word” option.
By utilizing these methods, you can ensure that each word in your string columns is properly formatted according to your requirements.
Additional References
