Looker Studio, formerly Google Data Studio, is a low-cost, easy-to-use business analytics solution....
Did you know that Slideform now supports conditional text formatting in your reports? This option allows you to change the color of text dynamically or to substitute words (such as "increase" or "decrease") on your slides depending on the value of a metric.
Automatically fill in text boxes in Google Slides and PowerPoint from any data source
Conditional Formatting in Slideform
To control the text color and content dynamically, use conditional formatting. Here is an example text box from a presentation.
The pragma variables are:
{{impressions}} - the number of impressions
{{imp_change}} - the amount of change compared to a prior period
The values for these pragmas are linked to a report in Looker Studio. I would like to change the color of the {{imp_change}} text so that it is green when the value goes up and red when it goes down.
I also want to add the words "Increased by" when the value is positive and "Decreased by" when it is negative.
Here's how to accomplish this formatting feat automatically!
Control Text Color:
Set conditional formatting on {{imp_change}}, so that a decrease in this metric will be shown in red and an increase will be in green. The formatting conditions are shown below:
Conditional Text Content:
To change the words that are shown in the pragma, you can set conditional formatting on so that text can be inserted based on the value of a pragma.
- If is positive, show the words "Increased by" before the percent change value.
- If is negative, show the words "Decreased by" before the percent change value.
The syntax of the Update text action is as shown below:
Note that these conditional formatting settings are added to the same pragma as the color settings. Just select the pragma, conditions, and then enter the new text in the box. Use a single set of curly braces to indicate where the original value of the pragma (i.e. the percent change) will be placed.
When you generate the output, you will see the content is dynamically colored and formatted. One month the report will say "increased" and the next month it may have "decreased". And you never have to manually edit the text or colors!
