Every managing partner asks two questions. Are we capturing the hours we should be? And which matters actually make money? Most firms can answer both, just not until weeks after the partners who pressed for the answer have moved on.
The reason is structural. Time entries live in the billing system, costs in accounting, matter details in practice management, and client records in the CRM. Those systems do not talk to each other until someone exports files at month-end and stitches them together in Excel spreadsheets, a process that is slow, manual, and prone to errors.
Law firms use Power BI to connect their practice management, time and billing, accounting, and CRM systems into a single reporting layer, then track billable hours, matter profitability, and firm financials from dashboards that refresh daily.
Most firms already own the tools; what they lack is a solution that joins the outputs. Power BI for law firms is that layer. The real change is about timing, not prettier charts. Once hours and matter margins are visible in near real time instead of quarterly, partners can still act on what they see.
That is the gap ESW has been closing since 2006, designing Power BI dashboards that pull from every system in a client’s Microsoft 365 environment.
What follows covers tracking hours, modeling matter profitability, the supporting dashboards, the architecture underneath, and the security model a firm must build in.
Key Takeaways
- Siloed billing, accounting, and practice systems delay every answer partners ask for.
- Track utilization, capture rates, and entry lag, not just total hours.
- Revenue becomes profit only after cost rates, overhead, and disbursements are applied.
- Agree on matter IDs, date tables, and metric definitions before building visuals.
- Row-level security and ethical walls belong in the data model.
- ESW has built Power BI dashboards for Microsoft 365 environments since 2006.
Tracking Billable Hours in Power BI
The Metrics That Belong on an Hours Dashboard
An hours dashboard should hold more than a running total. The metrics that earn their place are:
- Billable hours measured against both individual and firm targets
- Utilization by timekeeper, practice group, and seniority level
- Daily and weekly capture rates rather than monthly totals alone
- Entry lag, meaning the days between work performed and time recorded
- Unbilled work in progress aging past an acceptable threshold
- Non-billable time split by category, so you can see where billable resources go
Entry lag is the metric most firms leave out and the one that predicts the others. Time recorded three weeks late is recorded from memory, and memory rounds down.
Catching Shortfalls While They’re Still Fixable
A year-end report tells you what happened. A pace report tells you what is about to happen.
Set alerts against pace so the dashboard flags a timekeeper falling behind in week two, not in December. Put recorded hours and billed hours in the same view, which exposes write-downs at the source instead of burying them inside a realization percentage.
When a practice group misses its number, let the partner drill from the group total straight down and identify the individual matters causing it. That is where accountability comes from.
Workload distribution deserves its own tile. An uneven spread across attorneys is a leading indicator of two problems at once: burnout on one side of the group and idle capacity on the other. We have built the same view for teams outside legal.
Common Reporting Mistakes
Three mistakes show up again and again.
The first is treating every recorded hour as equal. Realization varies sharply by matter type, so 100 hours of one kind of work is not worth 100 hours of another.
The second is reporting hours without the rate attached. A healthy hours number can hide a revenue problem when the work mix shifts toward lower rates.
The third is letting each practice group define “billable” its own way. Once definitions drift, firm-wide totals stop reconciling, and partners stop trusting the management reports built on them.
Measuring Matter Profitability in Power BI
Why Revenue Is Not Profitability
A matter can bill heavily and still lose money. Revenue becomes profit only after cost is applied, and most reports in the legal industry never apply it.
Three inputs are usually missing: timekeeper cost rates, allocated overhead, and unrecovered disbursements. Add the write-offs and discounts granted after the invoice went out, and a matter that looked strong in a revenue report can land underwater.
Building the Profitability Model
Start by layering standard cost rates onto recorded hours by timekeeper, so every hour carries what it cost the firm to deliver. Then allocate expenses and disbursements down to the matter level instead of leaving them in a firm-wide bucket.
Fee structures need their own margin logic. Hourly, flat-fee, and contingency matters cannot share one calculation, and forcing them into one is the fastest way to create numbers a partner will reject.
Finally, roll the matter margin up to the client, practice area, and responsible partner. That rollup is where the useful conversations start.
What the Analysis Surfaces
The first run of a profitability model is usually uncomfortable, and that is the point. It tends to surface marquee clients running at negative margin, protected by the size of their revenue figure.
It shows practice areas and fee structures with returns much further apart than anyone assumed. It also exposes staffing leverage problems, where work is being done at a seniority mix the rate cannot support.
The longer-term payoff is pricing. Once a legal practice has a year of margin history, scoping and pricing new engagements stops being a guess and becomes decision-making backed by evidence.
Supporting Dashboards That Complete the Picture
These dashboards surround the core and turn raw activity into a readable picture of client and matter performance.
| Dashboard | What it covers |
| Matter and case management | Open vs. closed matters; matters by practice area, partner, associate, and status; case aging and upcoming deadlines; case outcomes and case values |
| Billing and collections | Billed, collected, and outstanding amounts; realization and collection rates; revenue by client, matter, attorney, and practice area; accounts receivable aging |
| Attorney performance | Revenue generated and collections per timekeeper; time spent by matter and practice area; target vs. actual on hours, revenue, and collections |
| Client analytics | Revenue and profitability by client; active matter counts and outstanding invoices; client concentration risk; trends in client activity over time |
| Firm financials | Monthly revenue and expenses; profitability by practice area; budget vs. actual; cash-flow indicators and forecasting |
The Executive Dashboard
One screen pulls the highest-level figure from each area and refreshes daily. This is the view partners use for strategic decisions.
| KPI | Current | Target |
| Active matters | 428 | n/a |
| Monthly revenue | $1.25M | $1.20M |
| Billable hours | 8,420 | 8,800 |
| Collection rate | 91% | 95% |
| Outstanding A/R | $680K | $500K |
| Revenue per attorney | $185K | $175K |
Reading the Gaps
A screen like this only works if people read the numbers in combination.
Revenue is ahead of target while hours run behind. Rate and mix are carrying the month. That is fine now and a problem next quarter, because this quarter’s hours shortfall becomes next quarter’s revenue shortfall.
Collection rate and outstanding A/R are one working-capital problem, not two separate metrics.
Revenue per attorney sitting above target does not offset the 380-hour gap underneath it. Those hours are the pipeline.
Every tile should drill through to the practice area, attorney, or client driving the variance. A number nobody can open is a number nobody will act on.
Power BI Architecture for Law Firms
Dashboards like this only work if the data underneath them is joined correctly. The flow is straightforward. Practice or case management, time and billing, accounting or ERP, and CRM all feed Power BI, which pushes out the partner, finance, and attorney dashboards.
Whether those systems run as cloud services or sit on a local SQL Server, the integration pattern is the same. The features that matter here are not exotic ones: a clean model, row-level security, and scheduled refresh cover most of what a firm needs.
What Each System Contributes
Practice and case management supplies matter files, status, practice area, responsible attorney, and key dates. Time and billing supplies timekeeper entries, rates, invoices, write-offs, and payments.
Accounting or ERP supplies expenses, trust activity, general ledger detail, and budgets. CRM supplies client records, relationship owners, and intake and pipeline data.
Modeling Decisions to Settle First
Settle three decisions before anyone builds a visual:
- A single matter ID that reconciles across all four systems
- A shared date table that aligns billing, time, and accounting periods
- Written definitions for “billable hour,” “active matter,” and “collected”
Skipping the third is the most expensive shortcut here. Definitions written after launch become arguments about whether the report is wrong.
Confidentiality, Security, and Governance
Law firm data carries ethical obligations that most BI deployments never face, so protecting sensitive information belongs in the build, not in a later phase.
Row-level security and role-based access control keep each attorney in front of only the matters and financial data they are authorized to see, so the right people end up with the right numbers.
Ethical walls between conflicting engagements need to be enforced in the data model itself, not by asking people to look away. Firm-wide financial visibility for management should stay separate from matter-level visibility for attorneys.
The governance essentials are short but not optional:
- Documented metric definitions any user can reference
- Workspace permissions reviewed on a set schedule
- A named owner for every scheduled refresh
- Audit trails showing who accessed which report
Rolling It Out
Phasing matters. Connect time and billing first and ship the billable hours dashboard, since it delivers value within weeks and gets timekeepers used to their own numbers.
Add accounting next to complete matter profitability. Layer practice management and CRM last for the matter, client, and firm views.
Budget a Power BI license for everyone who needs their own dashboards, and count the internal time investment as part of the cost, not just the software.
Firms already standardized on Microsoft products tend to move faster, because the modeling logic carries over from the Excel work your finance team already does.
Pilot with one practice group before any firm-wide release. Then reconcile the model against a closed period the partners already know. Adoption depends on the numbers matching what they already trust. If the report disagrees with last quarter’s known figures, you will spend six months defending it.
Getting Help From ESW
Joining four systems that were never designed to talk to each other is where most dashboard projects stall. ESW has done that work since 2006 as a U.S.-based Microsoft partner.
Our Power BI consulting services cover what a firm needs here: designing dashboards that pull from multiple data sources across your Microsoft 365 environment, modeling billable hours and matter margin against real cost rates, and configuring row-level security so each attorney sees only authorized data. We also train partners and staff to use them.
What Law Firms Gain From Power BI
The payoff is simple. Hours and matter margins become visible while there is still time to act on them, not at year-end, when the only option left is explaining them. Firms that get this far often move next to Copilot and AI agents, which work best on joined data.
A reasonable next step is small. Audit which of the four source systems your firm can realistically connect this quarter, focus on the one holding time and billing, and build from there.
If you have questions about tracking billable hours or measuring matter profitability in Power BI, just contact us. We are happy to help, whether you need a full build or a second opinion on the model you already have.