Scorecards are a fantastic way to present key performance indicators (KPIs) and other important metrics on your dashboard. They can show a single number, percentage, ratio, or currency value to the viewer, while other charts can help illustrate trends and patterns over time like time series or the breakdown of the KPIs across different categories and segments.
Scorecards can display compact numbers (e.g., 200k instead of 200,000), and you can also adjust decimal precision. They support various formats, such as numbers, ratios, and currencies.
Scorecards can show the comparison for the metric for a selected date range with another time period. The comparison period could be the previous period, previous year, or even a fixed or dynamic date range. Looker Studio handles these comparisons automatically, without needing extra data preparation.
To set up date range comparisons, access the settings for any chart that supports it. Under the date range options, you can choose the default date range, comparison date range, and more advanced settings.
Scorecards can display conditional formatting by changing the font or background color based on specific criteria. This helps communicate the status of a metric or KPI quickly to viewers. You can apply multiple conditional formatting rules to a single scorecard and they’ll be applied in order.
To access the settings for conditional formatting, select a scorecard or other component that supports it. Go to the style tab, where you can add different conditional formatting groups and choose colors for the font and background.
<aside> <img src="/icons/arrow-down-basic_blue.svg" alt="/icons/arrow-down-basic_blue.svg" width="40px" />
<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" width="40px" /> Enroll in Looker Studio Masterclass →
</aside>
📩 Receive my weekly Looker Studio tips
🖇 Connect with me on LinkedIn
</aside>
