The Swimming Pool Service KPI Dashboard in Power BI scores 12 pool-service KPIs against target every month, across 9 KPI groups, with MTD and YTD traffic lights on the same row. Pick a month and the whole report follows. Achievement is direction-aware: 5 of the 12 KPIs are higher-is-better and 7 are lower-is-better, so beating a chemical-cost, churn or callback target scores above 100% instead of reading as a failure. You get a fully editable .pbix, the Excel data pack that drives it and a user manual PDF, for one payment of $12.99 (regular $19.99) – no subscription, no per-seat licence, lifetime access to the file. Not what you needed? Tell us within 7 days and we will sort it out under our refund policy.Swimming Pool Service KPI Dashboard in Power BI
Which product is this? This is the KPI Dashboard line in Power BI: a month picker, a target-versus-actual scorecard, three-state traffic lights, a KPI Trend page and a KPI Definition page. It is not the analytical “Dashboard” line that slices revenue by route, technician or pool type, and it is not the lighter KPI Scorecard family, which is a single-file build with its own shorter KPI list – that one is already live as the Swimming Pool Service KPI Scorecard in Google Sheets. Three NextGenTemplates families carry deliberately similar pool-service names. Compare the page images above before you buy – and if you want more than one, they complement each other rather than repeat.
Also available in Excel – and it is a different build, not a port. The Swimming Pool Service KPI Dashboard in Excel is a separate workbook with 15 KPIs across 7 groups on 11 sheets. This Power BI edition runs 12 KPIs across 9 groups on 4 pages. Only two KPIs appear in both – Chemical Cost per Pool and Days Sales Outstanding. This edition adds Revenue per Pool per Month, Service Gross Margin % and Repair & Install Revenue Mix %, which the Excel edition does not carry; the Excel edition carries CSAT, Customer Retention Rate, On-Time Service Visits, First-Visit Fix Rate, Water Chemistry Pass Rate, Seasonal Contract Renewals and Equipment Install Jobs, which this one does not. Buy on the KPI list you actually report, not on the tool name.
Key Features of the Swimming Pool Service KPI Dashboard in Power BI
- 12 pool-service KPIs, scored not just displayed. Route Stops per Tech-Day, Missed or Skipped Stops, Chemistry Out-of-Range Visits, Service Callback Rate %, Technician Billable Utilisation %, Chemical Cost per Pool, Revenue per Pool per Month, Recurring Contract Churn %, Repair & Install Revenue Mix %, Service Gross Margin %, Days Sales Outstanding and Safety Incident Rate (TRIR).
- 9 KPI groups – Route Operations, Water Quality, Service Quality, Workforce, Cost, Revenue, Retention, Financial and Safety – so a monthly review runs group by group instead of number by number.
- Direction-aware achievement. Higher-is-better KPIs score Actual / Target. Lower-is-better KPIs score Target / Actual. That is why the shipped December sample scores Chemical Cost per Pool at 101.2% when the actual ($18.13 per pool) came in under the $18.35 target.
- Three-state traffic lights on two horizons. On Target at 100% or more, At Risk from 95% up to 100%, Missed below 95% – printed separately for MTD and for YTD, so a KPI that looks survivable this month but is behind for the year cannot hide. Missed or Skipped Stops does exactly that in the sample: At Risk for December at 97.1%, but Missed for the year at 90.1%.
- Five slicers, synced across pages – Month, KPI Group, Owner, Priority and Direction. Change one on the scorecard and the KPI Trend and KPI Definition pages follow.
- A 12-month sparkline inside every scorecard row, plus five summary cards (Total KPIs, MTD Target Met, MTD At Risk, MTD Target Missed, Achievement MTD), each with its own 12-month trend and a month-on-month delta.
- An owner and a priority against every KPI. The sample ships 9 named owners – Route Operations, Water Quality & Compliance, Field Service, Workforce Planning, Purchasing & Chemicals, Account Management, Repair & Installation, Finance and Safety & Compliance – at Critical (6 KPIs), High (4) or Medium (2).
- Real prior-year comparison. The data pack carries two full years of actuals – 2024 and 2025 – so every YoY arrow and every “PY” line on the trend charts comes from typed history, not from an estimate.
- Two hidden tooltip pages (KPI Detail and Trend Detail, 280×360) that surface on hover without adding clutter to the printed page.
- Native Power BI visuals only, plus one custom theme file that drives every colour. Nothing to install from AppSource, nothing that breaks when a custom visual is deprecated. 104 DAX measures sit behind the four pages.
What Is Inside the Swimming Pool Service KPI Dashboard in Power BI
The download is a single ZIP holding three files: the .pbix report, the Data.xlsx pack it reads from, and a Power BI Dashboard user manual PDF. Keep all three in one folder.
Page 1 – KPI Scorecard. Five slicers across the top, five summary cards under them, then the full scorecard table: KPI Name, KPI Group, Unit, a 12-month sparkline, Actual (MTD), Target (MTD), Achievement % (MTD), Status Light (MTD), YoY Arrow (MTD), Actual (YTD), Achievement % (YTD) and Status Light (YTD). Rows sort by achievement, worst first. The shipped December 2025 sample reads 12 KPIs, 6 met, 3 at risk, 3 missed and 98.7% achievement for the month – the three misses being Service Callback Rate % (92.1%), Recurring Contract Churn % (93.6%) and Repair & Install Revenue Mix % (94.3%).
Page 2 – KPI Trend. A “Select KPI Name” list on the left, six context cards naming the selected KPI, its group, unit, direction, owner and priority, five value cards (KPI Actual MTD, KPI Target MTD, KPI Achievement % MTD, KPI Status MTD, KPI YoY % MTD) and two line charts – CY MTD vs PY MTD vs Target MTD by Month and CY YTD vs PY YTD vs Target YTD by Month. Three lines on each: this year, last year, target.
Page 3 – KPI Definition. The same synced KPI selector, and then the part most KPI packs leave out: the formula and the plain-English definition for whichever KPI is selected. Chemical Cost per Pool, for example, reads “Chemical Spend / Pools Serviced” with the definition “Monthly chlorine, acid, algaecide and stabiliser cost carried by each pool on the route”. Under it sit a Monthly Detail for the Selected KPI table for all twelve months plus a total row, an MTD Actual vs Target by Month chart and an Achievement % by Month chart.
Page 4 – Get More Templates, a short catalogue and customisation page, plus the two hidden tooltip pages that never appear in the page tabs.
The data pack (Data.xlsx) has four sheets. Read Me explains the model, including the rule that a rate, ratio or index YTD is the average of the months so far and never a sum. KPI Definition is one row per KPI with group, unit, formula, definition, UTB/LTB type, owner and priority – 12 rows. Input_ Target holds 144 rows: 12 KPIs by 12 months, MTD and YTD. Input_ Actual holds 288 rows, because it carries 2024 as well as 2025. Nothing in the report hard-codes a KPI name: add a row, delete a row, or rename a KPI in all three sheets, press Home > Refresh, and the counts, the scorecard, the selector list and every chart follow.
Where the data comes from. The model is one imported table built from those three sheets, plus a Date table generated in Power Query. It connects to no live system – there is no API, no gateway and no route-management, accounting or telemetry connector. You type numbers into the workbook and refresh. The report opens with the sample data already loaded, so you can look around before touching anything; before your first Refresh, point the query at your own copy with Home > Transform data > Data source settings > Change Source, because the path saved in the file is the folder it was built in.
A Plain Note About Water Chemistry
One KPI on this dashboard touches pool chemistry: Chemistry Out-of-Range Visits, a monthly count of service visits that closed with free chlorine, pH or total alkalinity outside your own published range. The file does not store test readings. There is no field for a pH value, a chlorine ppm, a cyanuric acid level or a per-pool test log, and nothing in the model validates, interprets or certifies a reading.
This template makes no public-health, water-safety, chemical-compliance or testing-certification claim. It is a management reporting file. It is not a substitute for your health-department inspection regime, your state or local pool code, your chemical handling and safety-data-sheet obligations, or the judgement of a certified pool operator. The out-of-range count is a number your own process produces; the dashboard only trends it against a target you set. The same applies to Safety Incident Rate (TRIR): it is a figure you type in, not an OSHA recordkeeping system.
Swimming Pool Service KPI Dashboard in Power BI vs. Tableau or Qlik vs. Paid Pool-Service SaaS – Where This Fits
| This template (Power BI) | Tableau or Qlik build | Pool-service field SaaS analytics | |
|---|---|---|---|
| Cost | $12.99 once | Roughly $70-$115 per user per month for a creator seat, plus build time | Typically a per-technician monthly fee, four figures a year and up |
| Platform | Power BI Desktop, free from Microsoft (Windows) | Tableau Desktop or Qlik Sense | Vendor cloud, browser and mobile app |
| Setup time | Open, retype 12 KPI rows, refresh – under an hour | Days to weeks for the same scorecard | Weeks, plus route and customer data migration |
| Real-time team collaboration | No – publish to the Power BI Service if you need shared access | Yes, on a paid server | Yes |
| Mobile access | Via the free Power BI mobile app once published | Yes | Yes |
| Customisable fields | Every KPI, group, unit, formula, owner and priority is a spreadsheet row | Fully custom, but you write it | Limited to the vendor’s field model |
| Live route or technician GPS feed | No – you type monthly actuals into Data.xlsx and refresh | Possible, if you build the connection | Yes, that is the product |
| Per-pool chemistry log | No – the dashboard counts out-of-range visits, it does not store readings | Only if you build it | Usually yes |
| Year-1 cost at 5 users | $12.99, plus optional Power BI Pro seats if you publish | $4,200-$6,900 | Typically far higher again |
| Pool-specific KPI set out of the box | Yes – route stops, chemistry exceptions, callbacks, chemical cost per pool, contract churn | No – start from a blank canvas | Generic field-service metrics |
Who This Template Is For – and Who It Is Not For
It fits a residential or commercial pool-service company running anywhere from two routes to twenty, an operations manager who already reports monthly on stops, callbacks and chemical spend, an owner who wants recurring-contract churn and revenue per pool in front of the same meeting as route productivity, a service manager preparing a seasonal review before the summer ramp, or a Power BI user who wants a finished scorecard pattern to fork for another route-based trade.
It is not for you if you want live data off a technician’s phone – this reads a spreadsheet you refresh by hand. It is not for you if you want per-pool, per-route or per-technician drill-down: the report is a company-level monthly scorecard by design, and individual pools, routes and technicians are not dimensions in the model. It is not route-scheduling or dispatch software, it is not a customer database, it is not invoicing or accounting software, and it does not connect to Skimmer, Pool Brain, Jobber, ServiceTitan, QuickBooks or Xero. It is not a chemical dosing calculator or a water-testing record. Days Sales Outstanding here is a monitoring ratio you supply, not a receivables ledger. And it is not a safety or health-compliance system – see the water chemistry note above. Swimming Pool Service KPI Dashboard in Power BI
How to Use the Swimming Pool Service KPI Dashboard in Power BI
- Unzip all three files into one folder and keep them together – the report reads
Data.xlsxfrom beside it. - Open the
.pbixin Power BI Desktop, free from Microsoft and Windows-only. Have a look around first: the sample data is already loaded. - Repoint the source before your first refresh. Home > Transform data > Data source settings > Change Source, and select your copy of
Data.xlsx. The path saved in the file is the folder it was built in. - Edit the KPI Definition sheet first. One row per KPI: group, unit, formula, definition, Type (UTB for higher-is-better, LTB for lower-is-better), owner, priority. The KPI Name is the join key across all three sheets, so a rename has to happen in all three.
- Fill Input_ Target – one row per KPI per month, MTD and YTD, for the year you are reporting. Remember the Read Me rule: for a %, a Days figure or an index, the YTD value is the average of the months so far, never a sum.
- Fill Input_ Actual the same way, for the reporting year and the year before it. The prior year is what every PY line and YoY arrow reads from.
- Press Home > Refresh. Counts, cards, the scorecard table, the KPI selector and every chart follow.
- Pick a month on the KPI Scorecard. Then click a KPI on KPI Trend – the KPI Definition page shares that selection, so it already shows that KPI’s formula and monthly detail when you switch tabs. Swimming Pool Service KPI Dashboard in Power BI
Real-World Use Cases
Ray runs eleven residential routes. His monthly meeting used to open with a spreadsheet of raw totals and an argument about whether a number was good. Now it opens on the KPI Scorecard with Dec 2025 selected: 6 met, 3 at risk, 3 missed. The three misses – Service Callback Rate %, Recurring Contract Churn % and Repair & Install Revenue Mix % – each carry a named owner on the row, so the meeting becomes three conversations instead of twelve.
Bianca owns the accounts. Recurring Contract Churn % and Revenue per Pool per Month sit against her name. She selects churn on KPI Trend, sees the current-year line against target and against last year, and takes the twelve-month table off the KPI Definition page straight into the retention review – with the formula card beside it, so nobody relitigates how churn is calculated before the discussion starts.
Theo dispatches. He watches Route Stops per Tech-Day and Missed or Skipped Stops, and uses the Direction slicer to pull the whole scorecard down to the lower-is-better KPIs when he wants only the exception side of the month. In the sample, Missed or Skipped Stops is the KPI that reads At Risk for December but Missed for the year – the case the two-horizon traffic light exists for.
Frequently Asked Questions
Do I need a Power BI licence to use this?
No. Power BI Desktop is free from Microsoft and opens, edits and refreshes the file. It runs on Windows only. A Power BI Pro or Premium seat is needed only if you want to publish the report to the Power BI Service and share it with colleagues.
Can I add, remove or rename KPIs?
Yes, and that is the point of the build. Nothing in the report hard-codes a KPI. Add a row to KPI Definition plus its monthly Target and Actual rows, or delete those rows, or rename the KPI in all three sheets, then refresh. The counts, the scorecard, the selector list and every chart follow. Swimming Pool Service KPI Dashboard in Power BI
Does it store pool test readings or check water-safety compliance?
No. The only chemistry KPI is Chemistry Out-of-Range Visits, a monthly count you supply. There is no field for pH, free chlorine, total alkalinity, cyanuric acid or any per-pool test log, and the file makes no public-health, water-safety, chemical-compliance or testing-certification claim. It reports a number your own process already produces.
Is there a drill-through page?
No – and it is worth saying plainly, because builds in this family vary. There is no right-click drill-through in this report. The KPI Definition page is reached from the page tabs; its KPI selector is synced with the KPI Trend page’s selector, so whichever KPI you picked is already applied when you get there. Two hidden tooltip pages appear on hover, and those are the only hidden pages.
Does it connect to my route management or accounting system?
No. The model imports one Excel workbook and builds a Date table from it. There is no API, no gateway, no scheduled refresh against a live source and no connector to Skimmer, Pool Brain, Jobber, ServiceTitan, QuickBooks or Xero. Actuals and targets are typed into Data.xlsx.
Are the targets industry benchmarks?
No. Every figure in the file is sample data, including all twelve targets. There is no benchmark set, no industry average, no PHTA or Model Aquatic Health Code rule, no local pool-code rule and no external data source behind any number. Replace the targets with your own before anyone treats a traffic light as meaningful. Swimming Pool Service KPI Dashboard in Power BI
How is this different from the Excel edition of the same name?
They are two different builds, not one file exported twice. This Power BI edition runs 12 KPIs across 9 groups on 4 report pages. The Excel edition runs 15 KPIs across 7 groups on 11 sheets. Only Chemical Cost per Pool and Days Sales Outstanding appear in both. Revenue per Pool per Month, Service Gross Margin % and Repair & Install Revenue Mix % are unique to this one; CSAT, Customer Retention Rate, On-Time Service Visits, First-Visit Fix Rate, Water Chemistry Pass Rate, Seasonal Contract Renewals and Equipment Install Jobs are unique to the Excel one. Pick on the KPI list, or take both.
What exactly do I download?
One ZIP containing the .pbix report, Data.xlsx and a Power BI Dashboard user manual PDF. It is a one-time payment with lifetime access to the file you buy.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release. Swimming Pool Service KPI Dashboard in Power BI
Explore Related Templates
- Swimming Pool Service KPI Dashboard in Excel – the same topic, a genuinely different build: 15 KPIs, 7 groups, 11 sheets.
- Swimming Pool Service KPI Scorecard in Google Sheets – the lighter scorecard family, same trade, its own shorter KPI list.
- Plumbing Business KPI Dashboard in Power BI and HVAC Contractor KPI Dashboard in Power BI – the same scorecard build for neighbouring home-service trades.
- Landscaping Dashboard in Power BI and Pest Control Dashboard in Power BI – the analytical Dashboard line for other route-based services.
- Browse every Power BI template or the full KPI Dashboard category.
A full walkthrough of every page, with the sample December numbers explained, is on the blog: Swimming Pool Service KPI Dashboard in Power BI.
Buy the Swimming Pool Service KPI Dashboard in Power BI for $12.99 (regular $19.99), download it straight away, and have twelve pool-service KPIs scored against target in an afternoon. One payment, no subscription, lifetime access to the file.
Watch the step-by-step video Demo:
Last updated: 2 September 2026.
