Power BI Dashboard for SaaS: MRR and Churn

SaaS companies live or die by retention, yet most run their business on a billing export, a CRM dashboard and a product analytics tool that never agree. A Power BI dashboard for SaaS unifies billing, CRM and usage data into one governed model so that monthly recurring revenue, churn and net revenue retention are calculated once, consistently, and trusted by operators, finance and the board alike. It turns a monthly scramble into a live, defensible view of the business.

This guide sets out the metrics that matter, how to model an MRR waterfall, the product usage signals worth tracking, and how to connect the sources reliably.

The SaaS metrics that matter

A good SaaS dashboard pairs growth with retention. Growth alone flatters a leaky business.

• MRR and ARR: current recurring revenue, with its movements shown alongside the total.
• Net revenue retention (NRR): recurring revenue from existing customers this period versus last, including expansion and contraction. The single best health signal for a SaaS business.
• Gross revenue retention (GRR): the same view excluding expansion, showing pure leakage.
• Logo and revenue churn: customers lost and revenue lost, ideally segmented by plan or cohort.
• CAC and CAC payback: cost to acquire a customer and how many months of margin it takes to recover.
• LTV and LTV:CAC ratio: lifetime value against acquisition cost.
• Product engagement: active users, feature adoption and the usage signals that predict churn.

Modelling the MRR waterfall

The MRR waterfall is the centrepiece of SaaS reporting and the hardest thing to get right in a spreadsheet. In Power BI it becomes maintainable.

1. Build a monthly subscription snapshot. One row per customer per month with their recurring revenue. This is your fact table.
2. Classify each customer month with DAX. Compare a customer's revenue this month to last month to label it new, expansion, contraction, churned or reactivated.
3. Aggregate the movements. Sum each category to produce the classic waterfall: starting MRR, plus new, plus expansion, minus contraction, minus churn, equals ending MRR.
4. Derive NRR and GRR. Both fall straight out of the same model once movements are classified, so your retention metrics always reconcile to your revenue.

Getting the snapshot right is mostly a data engineering problem, not a visual one. If billing data is messy or split across systems, fix that first; our data integration and warehousing work is built for exactly this.

Product usage and engagement

Revenue tells you what already happened; product usage tells you what is about to. Bring engagement data alongside billing so you can see which accounts are at risk before they churn.

• Active accounts and users: daily and monthly active, trended.
• Feature adoption: which features correlate with retention and expansion.
• Health scoring: a composite of usage, support tickets and contract value to flag accounts for customer success.

This is where SaaS dashboards earn their keep: a customer success lead seeing declining usage in a high-value account has time to act.

Connecting the sources

Power BI can connect to these via native and third-party connectors or APIs, but production SaaS reporting almost always stages data in a warehouse or Microsoft Fabric lakehouse first. That ensures a customer in billing maps cleanly to the same customer in CRM and product data, so NRR and health scores are accurate rather than approximate.

Licensing and cost

Sharing a SaaS dashboard with your team needs Power BI Pro licences (low per-user monthly cost), or Premium Per User or Fabric capacity for larger audiences and advanced reporting features. Copilot in Power BI requires paid Fabric F2 or higher, or Power BI Premium P1 or higher capacity. Pro or Premium Per User alone is insufficient. Check administrator settings, supported region and access for the experience you plan to use. Microsoft licensing changes often, so check current Microsoft pricing.

UK Power BI day rates run roughly £400 to £850 per day. A scope-locked build typically ranges from £8,000 to £14,000 depending on the number of sources and the complexity of your MRR logic. A short paid review (£2,000 to £4,000, fee credited toward a build) confirms scope and data readiness first. Confirm current pricing as of 2026.

Getting started

If your MRR, churn and retention numbers depend on a fragile spreadsheet, the highest-value move is to put them on a governed model. Book a Trusted Numbers Review and we will map your billing, CRM and product data, agree your metric definitions and recommend the right build. You can also read about building a Power BI dashboard for finance for board-level reporting, or explore our full Power BI consultancy.