---
id: video/cV_5MGGdGtQ
type: video
title: Make your KPIs look sharp and dazzling in Business Central (Advanced Spreadsheets and Reporting)
summary: "KPI cards in the Advanced Spreadsheets and Reporting app for Business Central: a demo of a basic card, auto card type, compare value, target bar or donut, trend display and status with warning and critical levels. Useful for building KPI dashboards in spreadsheets."
tier: community
language: en
tags:
  - kpi cards
  - spreadsheet reporting
  - data visualization
  - dashboard design
  - compare values
  - trend display
  - status indicators
  - warning levels
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:18:22.799Z"
  flags: []
generated:
  at: "2026-10-13T00:32:41.360Z"
  pipeline: 0.2.0
  prompts:
    extract-video: 1
    summarize-video: 2
  input_hash: 8193916a80c9851e7082c9d3d13fdc9a578fcd88be5e77683956ffb68947e725
evidence:
  - kind: video
    url: https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=0s
    title: Make your KPIs look sharp and dazzling in Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 0
    quote: How to make your KPIs look sharp and dazzling with the advanced spreadsheet and reporting app for Business Central.
  - kind: video
    url: https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=96s
    title: Make your KPIs look sharp and dazzling in Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 96
    quote: So right now we have just set it to card type auto so it will try to depending on what settings you have the
  - kind: video
    url: https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=127s
    title: Make your KPIs look sharp and dazzling in Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 127
    quote: So, if we go back into the KPI card and then we select the um the compare value.
  - kind: video
    url: https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=201s
    title: Make your KPIs look sharp and dazzling in Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 201
    quote: Uh so, now we get a target bar saying hey, the target is 1,200. We are 83% there.
  - kind: video
    url: https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=295s
    title: Make your KPIs look sharp and dazzling in Business Central (Advanced Spreadsheets and Reporting)
    date: "2026-09-21T19:14:15.000Z"
    commit: null
    t: 295
    quote: So, the last one is a status. Um And right now we're on track. Because we have not really specified what we are uh
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
video_id: cV_5MGGdGtQ
channel: yt-hougaard
source_name: Erik Hougaard
url: https://www.youtube.com/watch?v=cV_5MGGdGtQ
published_at: "2026-09-21T19:14:15.000Z"
duration_s: 386
captions: derived
audience:
  - functional consultant
  - developer
  - end user
chapters:
  - t: 0
    title: Introduction to KPI cards
  - t: 20
    title: Creating a basic KPI card
  - t: 52
    title: KPI card formatting and auto type
  - t: 116
    title: Comparing values and setting labels
  - t: 188
    title: Target visualization and trend display
  - t: 249
    title: Status indicators and warning levels
  - t: 360
    title: Summary and call to action
features:
  - name: KPI card
    status: unclear
    t: 42
    verified: false
    status_source: video
  - name: KPI card auto type
    status: unclear
    t: 96
    verified: false
    status_source: video
  - name: KPI compare value
    status: unclear
    t: 116
    verified: false
    status_source: video
  - name: KPI target bar visualization
    status: unclear
    t: 188
    verified: false
    status_source: video
  - name: KPI trend display
    status: unclear
    t: 214
    verified: false
    status_source: video
  - name: KPI status with warning levels
    status: unclear
    t: 284
    verified: false
    status_source: video
objects_mentioned: []
quotes:
  - t: 0
    text: How to make your KPIs look sharp and dazzling with the advanced spreadsheet and reporting app for Business Central.
    check: exact
  - t: 96
    text: So right now we have just set it to card type auto so it will try to depending on what settings you have the
    check: exact
  - t: 127
    text: So, if we go back into the KPI card and then we select the um the compare value.
    check: exact
  - t: 201
    text: Uh so, now we get a target bar saying hey, the target is 1,200. We are 83% there.
    check: exact
  - t: 295
    text: So, the last one is a status. Um And right now we're on track. Because we have not really specified what we are uh
    check: exact
---

# Make your KPIs look sharp and dazzling in Business Central (Advanced Spreadsheets and Reporting)

> KPI cards in the Advanced Spreadsheets and Reporting app for Business Central: a demo of a basic card, auto card type, compare value, target bar or donut, trend display and status with warning and critical levels. Useful for building KPI dashboards in spreadsheets.

[Watch on YouTube](https://www.youtube.com/watch?v=cV_5MGGdGtQ) · Erik Hougaard · 2026-09-21 · 6:26 · tier community · reviewed (checked by Opus)

## Overview

Erik Hougaard shows how to format KPIs as cards using the Advanced Spreadsheets and Reporting app for Business Central. He starts with a basic KPI card and the auto card type, which formats the card based on the settings you have defined.

He then adds a compare value to show whether the main value is above or below another value, a target visualization (for example a target of 1,200 with 83% reached), a trend display, and a status indicator with warning and critical levels. The video ends by suggesting the cards as building blocks for a dashboard of KPIs.

## Key points

- A KPI card can show a value, a comparison, a trend, a target and a status.
- Card type auto formats the card depending on the settings you have defined.
- A compare value shows whether the main value is above or below the comparison value.
- The target visualization shows progress as a percentage, in the demo a target of 1,200 with 83% reached, and can be a bar or a donut chart.
- The trend display shows movement over time without a full chart with numbers.
- Status uses warning and critical levels; the two can be combined and the direction can be changed.
- Without specified levels, the status in the demo showed as on track.

## Chapters

- [0:00](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=0s) Introduction to KPI cards
- [0:20](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=20s) Creating a basic KPI card
- [0:52](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=52s) KPI card formatting and auto type
- [1:56](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=116s) Comparing values and setting labels
- [3:08](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=188s) Target visualization and trend display
- [4:09](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=249s) Status indicators and warning levels
- [6:00](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=360s) Summary and call to action

## Features

Every feature below: status not stated, demoed.

| Feature | At |
|---|---|
| KPI card | [0:42](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=42s) |
| KPI card auto type | [1:36](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=96s) |
| KPI compare value | [1:56](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=116s) |
| KPI target bar visualization | [3:08](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=188s) |
| KPI trend display | [3:34](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=214s) |
| KPI status with warning levels | [4:44](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=284s) |

## Quotes

- [0:00](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=0s) "How to make your KPIs look sharp and dazzling with the advanced spreadsheet and reporting app for Business Central."
- [1:36](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=96s) "So right now we have just set it to card type auto so it will try to depending on what settings you have the"
- [2:07](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=127s) "So, if we go back into the KPI card and then we select the um the compare value."
- [3:21](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=201s) "Uh so, now we get a target bar saying hey, the target is 1,200. We are 83% there."
- [4:55](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=295s) "So, the last one is a status. Um And right now we're on track. Because we have not really specified what we are uh"

## Disclaimers in the video

- [6:10](https://www.youtube.com/watch?v=cV_5MGGdGtQ&t=370s) other: If you want to try it out yourself, follow the links below and you can try the advanced advanced spreadsheet ...

Presenters (as heard): Eric.