Power BI referral dashboard for dental practices: the numbers worth one page
A useful Power BI referral dashboard for a dental specialty practice fits on one page and answers five questions: how many referrals came in this month, how that compares with last month and the same month last year, which referrers went up, which went down, and how many referrals have no doctor attached. Show those as plain numbers and short ranked lists, use a line chart only for a single doctor's trend over time, and leave pie charts out.
Everything else can go on a second page.
Why do referral dashboards end up so hard to read?
Most practice dashboards grow one request at a time. A donut here, a filter there, and a year later the report has eight pages and nobody opens past the first one.
The people who use a referral report have one job: decide which offices to thank and which to visit this week. A rep heading out on Tuesday needs that in a glance, without clicking through filters. Microsoft's own Power BI design guidance says the same thing: keep the tiles on one screen, and remove everything but the essential information.
Which numbers belong on a one-page referral dashboard?
Here's a layout that works, top left to bottom right, since that's the order people read.
| Spot on the page | What it shows | Why it earns the space |
|---|---|---|
| Top row, big numbers | Referrals this month, last month, same month last year | The headline. One glance tells you if the month was normal |
| Top row, big number | Unattributed referrals ("Dentist", blank, or "other") | Tells you how much to trust everything else on the page |
| Middle, left | Top increases: referrers up the most against their usual pace | Who to thank this week |
| Middle, right | Top decreases: referrers down the most | Who to visit and check in with |
| Bottom | Top referrers for the trailing twelve months, sortable | The relationships that carry the practice |
| Drill through | One doctor's monthly referrals as a line | The trend behind any name on the page |
Keep the time frames consistent. Microsoft's tips warn against putting last month next to a chart filtered to a different month, and referral pages break this rule all the time. If the top row says September, every list on the page should say September or the twelve months ending in September.
Compare a referrer against their own history, not against the office down the street. An office that usually sends one patient a quarter and sent none this month is not a crisis. An office that sends four a month and sent none is worth a call. If you want help reading those drops, we wrote up why a dentist stops referring and how to reconnect.
Why line charts and numbers instead of pie charts?
Pie charts show parts of a whole, and they work only with a few categories. A practice with sixty referring doctors gets sixty slivers that nobody can compare. Microsoft's guidance says pie, donut, gauge and other circular charts "aren't ideal" and recommends bars for comparing values side by side, while its visuals overview describes line charts as ideal for showing trends over time.
In practice that means:
- Big numbers for the month, so nobody has to read an axis.
- Ranked lists or bars for increases and decreases.
- A line for one doctor's referrals across twelve months.
One caution on lines: a practice wide total by month can swing a lot from one month to the next, so the line looks dramatic without telling you much. The line earns its place on the single doctor view, where a slow slide is exactly what you want to catch.
What has to be right in the practice software first?
A dashboard only repeats what the front desk entered. Before you rebuild a single visual, look at how referral source gets captured at intake:
- Pick one spelling per doctor. "Dr. Rivera", "Rivera DDS" and "J Rivera" (a made up example) show up as three referrers with small numbers instead of one strong one.
- Ask for the doctor, not just "dentist". A referral marked "Dentist" counts in your total and helps no relationship. Track that unattributed number on the dashboard so it stays visible.
- Record the referring doctor, not only the office. When a dentist joins or leaves an office, the doctor field keeps the history straight. That is also how you notice a new dentist at an office that already refers to you.
When is a purpose-built view simpler than building your own?
Power BI is a strong tool, and if your practice or group already has someone who maintains reports, the layout above is a good afternoon of work. A purpose-built view tends to be simpler when:
- Nobody in the office owns the report, so changes wait weeks.
- The person who reads it is a rep or coordinator who needs a to-do list, not a chart.
- You want the numbers next to relationship notes, upcoming visits and offices you haven't met yet, which a reporting tool wasn't designed to hold.
Occlu takes that route: it reads the referral reports you already export, and we do the setup. For other routes, including when a spreadsheet is enough, see our comparison of orthodontic referral tracking software.
Common questions
Should I count referrals by doctor or by office?
Track both, but lead with the doctor. Referrals come from people, and when an associate moves to a new office, the doctor view shows you where the relationship went. Roll up to the office when you plan visits.
How often should a referral dashboard refresh?
Monthly is enough for most specialty practices. Referrals from any one office are small numbers, so weekly views mostly show noise. Look at the month once it closes, and at the trailing twelve months for trends.
Get the one page view without maintaining the report
If you'd rather not maintain the report yourself, email us about becoming a founding practice, and we'll set it up from your current exports.
Or email us at info@getocclu.com