Variance Is a Question. A Red Tile Is Not an Answer.

The tile turned red. The room went quiet. Someone said “we should look into that.”

Nobody left with a driver, an owner, or a decision. Color did its job. Commentary never arrived.

Red and green are signals. They are not the brief

Executives do not need prettier conditional formatting. They need a path from “off plan” to “what changed, who owns it, and what we do before the next review.”

A KPI tile that only paints is a traffic light. Useful at a glance. Incomplete as a management product. The variance is the question. The answer is the driver at the grain the decision uses, plus an owner who can act.

This is not a fight about definitions of margin or revenue. Those fights belong in margin definitions that don’t survive a meeting and measures nobody can explain. Here the measure may be trusted. The tile still fails because color replaces analysis.

Finance feels this hardest in the monthly review. Ops feels it in the weekly scorecard. Commercial feels it when bookings miss and the page offers a red number with no cut ready.

Power BI can show the signal and support the next cut on the same model. It cannot invent judgment. It can stop pretending that red equals done.

The costs of stopping at the red tile

1. The meeting narrates color instead of causes. “Margin is red.” “Volume is green.” Twenty minutes later the room still does not know whether mix, price, cost, or timing moved. The agenda advanced. The decision did not.

2. Follow-ups leave the trusted model. Someone promises a “deeper look.” The look becomes a private workbook. By next week the red tile is still red and the explanation lives in email. The official page taught the signal. It never taught the path.

3. Owners stay attached to the slide, not the outcome. When the only artifact is a colored KPI, accountability defaults to whoever presents. When drivers sit beside the measure, accountability can sit with the leader who owns volume, price, plant cost, or pipeline.

4. Thresholds become politics. Without a written rule for when red means act, every color invites debate. Is two percent material? Is it seasonal? Is it noise? The tile cannot say. The operating rule never got written.

5. Noise trains leaders to ignore the board. Constant red with no consequence teaches the room to skim. Constant green with buried risk teaches the same. Signal without action path is decoration that erodes trust.

6. Analysts rebuild the same variance story each cycle. Same KPI. Same surprise. Same manual bridge. The model could hold the bridge dimensions. Instead capacity goes to screenshots and commentary packs.

7. Conversational follow-ups have nowhere safe to land. A leader may ask why the number moved. If the model lacks an approved driver cut, the answer is improvisation. Speed without a governed path is just faster confusion.

8. The pack grows commentary footnotes instead of product. Pages accumulate text boxes and “see notes.” Notes are not measures. They do not refresh. They do not assign owners. They paper over a missing decision design.

How to fix it: design variance as a decision path

1. Write the question the tile is allowed to ask. “Are we off the operating plan on gross margin enough to force a choice this month?” is a question. “Make margin red below target” is a format rule. Start with the management question.

2. Define materiality in plain language. State the threshold, the comparison (plan, forecast, prior period), and the as-of timing. Put it where stewards and leaders can find it. Color without a rule is taste.

3. Name the driver dimensions before you paint. Volume, price, mix, cost, timing, one-time items—whatever your business actually uses. The semantic model should support those cuts. If it cannot, the red tile will always end in a side analysis.

4. Put the first bridge on the decision page. Not a novel. A small, governed variance view the room can open in the same meeting. The point is to move from signal to candidate cause without leaving the trusted model.

5. Assign a business owner beside the KPI. The steward owns the measure definition. The commercial, plant, or finance leader owns the result. Red without an owner becomes a group shrug.

6. Require an act-or-accept rule in the minutes. When a variance is material, the room either assigns an action with a due date or explicitly accepts the miss. “Look into it” is not a third option that survives the meeting.

7. Stop shipping new colors as progress. Conditional formatting is cheap. Decision paths are the work. Fund the driver grain and the owner map before you fund another theme or another sparkline.

8. Capture repeated unexplained variances as backlog. If the same red tile needs a private bridge every month, you do not have a communication problem. You have a missing dimension, measure, or grain. Put it on the model backlog with a decision owner.

9. Review one KPI end to end. Pick margin, service level, or forecast accuracy. Trace signal → driver cut → owner → action. Fix that path. Then repeat. Do not relaunch the whole scorecard with prettier reds.

What a useful variance page looks like

The KPI still uses color. Color is fine as a skim layer.

Under it sits the comparison the company agreed to use. Beside it sits the owner. One click away sits the first approved bridge at the grain the decision needs—customer, product line, plant, or channel—not a blank canvas.

The room spends less time announcing that something is red. It spends more time choosing whether to change price, mix, capacity, or the plan itself.

Commentary still exists. Leaders still interpret. Power BI does not replace the CFO’s judgment. It stops pretending that a paint rule was the deliverable.

When finance and ops still disagree on the number itself, fix the definition and timing first. When they agree the number is off and still cannot act, you have the red-tile problem.

Executive takeaway

A red tile is a question mark with formatting.

Executives need the driver, the owner, and a clear act-or-accept path before the meeting ends. Build that path on the trusted model. Treat color as the headline, not the brief.

Need a 30-minute look at where your KPI color stops and the decision should start? Contact Alluvium. We’ll map one variance, its driver cuts, and the owner rule the room is missing.

Book a 30-minute consult.