Use Power BI's AI to Auto-Generate KPI Narratives
What This Does
Power BI's AI features automatically write narrative summaries of your revenue cycle dashboards — turning raw metric changes into plain-English paragraphs that explain what changed, by how much, and why. This eliminates the most time-consuming part of weekly and monthly reporting: converting numbers into words.
Before You Start
- You have Power BI (included in Microsoft 365 Business or available at $10/month standalone)
- Your revenue cycle data is connected to Power BI (from Epic, your clearinghouse, or an Excel export)
- You have a dashboard or report already built with your key metrics (Days in AR, Denial Rate, Clean Claim Rate, etc.)
Steps
1. Open your revenue cycle dashboard in Power BI
Go to app.powerbi.com → sign in → navigate to your Revenue Cycle report → open it.
What you should see: Your dashboard with KPI tiles showing days in AR, denial rate, collections by payer, etc.
2. Add a Smart Narrative visual to your report
Click Edit to enter editing mode → in the Visualizations pane on the right, click the Smart Narrative icon (looks like a text box with a lightbulb) → drag it onto an empty area of your report canvas.
What you should see: A text box appears with an automatically generated narrative summarizing the data visible in your current report view.
3. Read and customize the auto-generated narrative
The Smart Narrative automatically writes statements like: "Days in AR increased by 3.2 days to 45.8, driven by a 12% increase in commercial payer denials in the Northeast region."
Click on the narrative box → use the Value suggestions in the right pane to add additional metrics you want the narrative to reference.
What you should see: A paragraph describing the key metric movements, with the specific numbers pulled directly from your data.
4. Use Copilot in Power BI (if available on your plan)
Click the Copilot button in the Power BI toolbar → a chat panel opens → ask questions like:
"Summarize what changed in our denial metrics this week compared to last week."
"Which 3 payers are driving the increase in days in AR? Explain in plain language."
"Write an executive summary of this month's revenue cycle performance for our CFO who doesn't know billing terminology."
What you should see: Copilot generates a written summary you can copy directly into your weekly report or send as a standalone update.
5. Copy the narrative into your report template
Select the generated narrative text → copy → paste into your weekly KPI report document (Word, email, or PowerPoint) → review for accuracy → done.
Real Example
Scenario: It's Friday afternoon and you need to send your weekly revenue cycle update to the CFO before 5 PM. Your data is already in Power BI but you need a 150-word narrative to send with the dashboard.
What you ask Copilot:
"Write a 150-word executive summary of this week's revenue cycle metrics. Focus on: (1) overall performance vs. targets, (2) what's causing the increase in days in AR, (3) what we're doing about the spike in commercial payer denials. Use plain language — no billing jargon."
What you get: A ready-to-send paragraph that a non-finance executive can understand, with specific numbers pulled from your actual data.
Time saved: 60–90 minutes of weekly report narrative writing reduced to 5–10 minutes of review.
Tips
- Smart Narrative is dynamic — when your data refreshes, the narrative updates automatically, so you can add it to weekly recurring reports that update themselves
- If the Smart Narrative language sounds too mechanical, edit specific phrases — the AI does the structure work, you do the final polish
- Pin the Smart Narrative to your dashboard so it's the first thing leadership sees when they open the report
Tool interfaces change — if a button has moved, look for similar AI/magic/smart options in the same menu area.