> ## Content Index
> Fetch the complete content index at: https://brilaro.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Build advanced charts in Power Apps with QuickChart
- URL: https://brilaro.com/build-advanced-charts-in-power-apps-with-quickchart/
- Published: 2026-10-06T03:14:07.000Z
- Updated: 2026-10-06T04:33:52.000Z
- Author: Neal
- Tags: Power Apps: Canvas

Power Apps' built-in chart controls are limited in type and styling, but QuickChart turns any Chart.js configuration into an image, so a single URL in an Image control gets you labeled bars, doughnuts, radar charts and more.

## Before you start

1. **Check where your data goes.** The public `quickchart.io` endpoint receives everything in the URL. For sensitive or regulated data, self-host QuickChart (it's open source and ships as a Docker image) and swap the base URL.
2. **Summarize first.** The chart config travels in the URL, so send aggregated values (a few dozen points), not raw rows.
3. **Replace the placeholder names** below — `Tickets` (list) and `Program` (Choice column) — with your own.

## Step 1: Summarize the data

Run this from `OnVisible` of the screen or from a button's `OnSelect`.

```
// One row per Program with a count of tickets
ClearCollect(
    colChartData,
    AddColumns(
        GroupBy(
            AddColumns(Tickets, ProgramName, Program.Value),
            ProgramName,
            ProgramRows
        ),
        TicketCount, CountRows(ProgramRows)
    )
);
```

> **Note:** `GroupBy` isn't delegable, so it only sees the rows Power Apps loaded (2,000 max). For larger lists, load everything first with [Retrieve more than 2,000 rows from a SharePoint list in Power Apps](https://brilaro.com/retrieve-more-than-2-000-rows-from-a-sharepoint-list-in-power-apps/) and group `colAllItems` instead.

## Step 2: Render the chart

Insert an **Image** control, size it to roughly 600 × 350, and set its `Image` property:

```
With(
    {
        // 'Label A','Label B',...  (escape apostrophes in names)
        Labels: Concat(colChartData, "'" & Substitute(ProgramName, "'", "\'") & "'", ","),
        // 12,7,30,...
        Values: Concat(colChartData, TicketCount, ",")
    },
    "https://quickchart.io/chart?v=2.9.4&w=600&h=350&bkg=white&c=" &
    EncodeUrl(
        "{
            type: 'bar',
            data: {
                labels: [" & Labels & "],
                datasets: [{
                    label: 'Tickets',
                    backgroundColor: 'rgba(115, 118, 120, 1)',
                    borderWidth: 1,
                    data: [" & Values & "]
                }]
            },
            options: {
                legend: { display: false },
                title: {
                    display: true,
                    text: 'Ticket Volume by Program',
                    fontSize: 20,
                    fontColor: '#000',
                    fontStyle: 'bold'
                },
                scales: {
                    xAxes: [{ gridLines: { display: false } }],
                    yAxes: [{ gridLines: { display: false }, ticks: { beginAtZero: true } }]
                },
                plugins: {
                    datalabels: { display: true, anchor: 'end', align: 'top' }
                }
            }
        }"
    )
)
```

### How it works

- `With` builds the label and value lists once, so the config stays readable.
- `Concat(..., ",")` joins values with a separator, with no trailing comma to clean up.
- `EncodeUrl` makes spaces, `#`, `&` and line breaks URL-safe. Without it, a program name like "R&D" breaks the chart.
- `v=2.9.4` pins Chart.js 2, which matches the `xAxes`/`yAxes` syntax. The `datalabels` plugin is built into QuickChart.
- The Image control refreshes whenever `colChartData` changes, so re-running Step 1 updates the chart.

## Change the chart type

Swap `type: 'bar'` for any of these. Everything else stays the same.

| Type           | Best for                                        |
| -------------- | ----------------------------------------------- |
| horizontalBar  | Long category names                             |
| line           | Trends over time                                |
| pie / doughnut | Share of a total (keep it to 6 slices or fewer) |
| radar          | Comparing several metrics per item              |
| polarArea      | Magnitude by category                           |

For pie and doughnut charts, pass one color per slice and drop the `scales` block:

```
backgroundColor: ['#4E79A7', '#F28E2B', '#E15759', '#76B7B2', '#59A14F', '#EDC948']
```

## When should I use QuickChart?

- **Use the built-in chart controls** for simple charts where you need click events on chart items.
- **Use QuickChart** when you need data labels, custom styling, or chart types Power Apps doesn't offer. The result is a static image, so it can't be clicked by chart item.

> **Tip:** To debug a chart, set a Label's `Text` to the same formula, copy the URL into a browser, and read QuickChart's error message. For sharper output on high-resolution screens, add `&devicePixelRatio=2` to the URL.