Skip to content

Power BI-style dashboard builder

The report layouts teams build in Power BI: sales, HR, finance KPIs and operations. Edit them here, then take the Excel file into Power BI or PowerPoint.

New here? — takes 2 minutes.

Sales performance report

Power BI-style sales layout — Rolling 12 months to September

Sales

$12.6m
+9.4% YoY

Gross profit

$4.9m
+11.2% YoY

Gross margin

38.9%
+0.6 pts

Units sold

84,210
+6.8% YoY

Sales by month vs last year ($k)

This yearLast year
0
400
800
1.2k
1.6k
This year: 880Last year: 800
This year: 920Last year: 850
This year: 1.1kLast year: 1k
This year: 860Last year: 790
This year: 870Last year: 800
This year: 980Last year: 900
This year: 1kLast year: 920
This year: 1kLast year: 950
This year: 1.1kLast year: 1k
This year: 1.2kLast year: 1.1k
This year: 1.2kLast year: 1.1k
This year: 1.4kLast year: 1.2k
OctNovDecJanFebMarAprMayJunJulAugSep

Sales by category ($m)

12.6$m
Hardware5 40%
Software licenses3.9 31%
Services2.4 19%
Accessories1.3 10%

Top sales reps ($k)

Dana Whitfield1.5k
Marco Reyes1.3k
Priya Natarajan1.2k
Owen Clarke1.1k
Lena Fischer980
Sam Okafor910

Sales by region

RegionSalesvs LYMargin
West, good$3.9m+12.4%40.1%
Northeast, good$3.1m+8.9%39.4%
Southeast, good$2.4m+10.2%37.8%
Midwest, warning$1.9m+3.1%37.2%
Southwest, good$1.3m+6.5%38.0%

4 Power BI Dashboard templates

Every template opens as a finished dashboard. Pick the closest one, then change anything.

Using this dashboard in Power BI

  1. 1

    Get the data in long format

    Open Download ▾ › Data for Power BI, Tableau, Sheets (.csv). Every number on the dashboard becomes one row (widget, series, category, value), which is the shape Power BI models best.

  2. 2

    Load it

    In Power BI Desktop choose Get data › Text/CSV, pick the file and select Load. Filter on the widget column to rebuild each chart.

  3. 3

    Match the colours

    Download Power BI theme (.json) from the same menu, then View › Themes › Browse for themes. Your charts take this dashboard’s palette.

  4. 4

    Present it

    For a meeting, the PowerPoint download keeps every chart editable — or use the report pack for a summary slide plus one slide per chart.

Metrics and how to calculate them

The KPIs these templates are built on, with the formula behind each one.

Gross margin
(Sales − cost of goods sold) ÷ sales × 100.
Turnover rate
Leavers in the last 12 months ÷ average headcount over those months × 100.
EBITDA margin
Earnings before interest, tax, depreciation and amortization ÷ revenue × 100.
DSO
Accounts receivable ÷ revenue for the period × days in the period.
OTIF
Orders delivered complete and on the promised date ÷ all orders delivered × 100.
Inventory turns
Cost of goods sold over 12 months ÷ average inventory value.

How to make your Power BI Dashboard

Pick a template, put your numbers in, download — about two minutes. Nothing to install; the PDF and every other format come with a SlideTeam plan.

  1. 1

    Pick your dashboard

    Click Pick Your Dashboard. This dashboard has 4 ready-made layouts, such as Sales report (Power BI-style) and HR report (Power BI-style). Each opens finished, with example figures.

  2. 2

    Change the numbers

    Point at any widget (tap it on a phone) and choose Edit to type or paste its numbers and labels — a column copied from Excel pastes straight in. Click the dashboard's title to rename it.

  3. 3

    Use your own data

    Upload CSV or Excel takes a CSV, .xlsx or .xls file and shows exactly what it read: pick the sheet, the label column and how repeated rows are combined (sum, average, count), then Build a new dashboard or Fill this template with your columns. Not sure of the layout? Download the sample CSV and replace the numbers.

  4. 4

    Download PDF, PowerPoint, Excel and more

    Download (right end of the toolbar) lists every format: a PDF (free), PowerPoint with native charts you can still edit (right-click › Edit data), a report pack (summary slide plus one slide per chart) as PowerPoint or PDF, Excel (opens on a Dashboard sheet with live charts) and a CSV for Power BI, Tableau or Google Sheets.

  5. 5

    More options: add widgets, brand it, share

    More options (top right) shows the rest: Add widget puts in a chart, KPI tile, table, funnel or a Text / commentary box; the arrows on a widget move it and ✕ removes it; click the subtitle to edit it. Customise sets the currency, template language, slide size, brand colour and logo. Sheets / Slides shows how to open your file in Google Sheets or Slides; Share copies a link to this exact dashboard.

Common questions

Is this a Power BI template?

No. These are Power BI-style layouts — the report pages teams usually build in Power BI — made in a free builder that is not affiliated with Microsoft. Use them to agree a design, present the numbers, or hand the data to whoever builds the Power BI report.

How do I take this dashboard into Power BI?

Download Excel: each chart's data sits on its own sheet named after the chart. In Power BI Desktop choose Get data, then Excel workbook, tick those sheets, load them, and rebuild each visual with the same fields.

What should a Power BI HR dashboard show?

Headcount, 12-month turnover, tenure and absenteeism, with turnover by department and the hiring funnel underneath. The HR report template lays this out on one page.

Can I present a Power BI-style report without a Power BI license?

Yes. Download PowerPoint and you get a slide with native charts anyone can edit, so the report can go into a board pack without viewers needing access to the BI service.

Goes well with this — from our other free tools

The figures in the example dashboards are illustrative and exist so each page shows a finished dashboard rather than an empty grid. Replace them with yours before sharing anything.