As the name implies, the Find and Replace option searches a particular dimension column for a string or value and replaces it with the given string. Let's consider a Global market report to demonstrate this.
Sample report
We'll look at the inputs required to replace the "Bovespa Index" benchmark with "S&P 500" in the Benchmark column.
Find and Replace configuration
Target columns: You can select one or more columns from the dropdowns. These columns will be searched and replaced with the given value if the search string is found.
Find: The string to search for.
Match Case: You can opt for a fuzzy match, exact match or even provide a regular expression. Let's use a regex to replace all the Benchmarks that contain "Bovespa Index".
Find and replace with regular expressions
Replace with: The new string/value that will replace the search string.
Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
.png)
.png)
.png)
