Back to Blog

Use Report Themes in Power BI to Stop Every Dashboard Looking Different

August 9, 20269 min readMichael Ridland

Walk into most organisations that have been using Power BI for a couple of years and you will find the same thing. Forty dashboards, built by fifteen different people, and every single one of them looks like it came from a different company. One uses the default blue. One is all corporate green because someone found the brand guidelines. One is a rainbow of colours picked at random because the author just wanted the bars to look different. It is a mess, and it makes the whole reporting estate feel amateur even when the underlying data work is excellent.

Report themes are how you fix that, and they are one of the more underused features in Power BI Desktop. They let you define colours, fonts, and visual styling once, then apply that consistently across every report. Microsoft's documentation on report themes covers the mechanics. What I want to do here is give you the consulting view: why themes matter more than people think, how we actually roll them out for clients, and the bits that are still annoying.

Why consistency is worth caring about

There is a temptation to treat theming as cosmetic. It looks nice, sure, but does it actually matter? Yes, and for a reason that is not really about aesthetics.

When every report in an organisation shares a visual language, people read them faster. If red always means "bad" and green always means "good" across every dashboard, a manager glancing at a report they have never seen before still knows instantly what they are looking at. If the same brand colour always marks the primary metric, the eye goes straight to it. Consistency is not decoration, it is a form of speed. It reduces the tiny cognitive tax of relearning how to read each new report.

The flip side is trust. A reporting estate where every dashboard looks slapped together makes stakeholders quietly doubt the numbers, even when the numbers are perfect. Presentation and credibility are linked in people's heads whether we like it or not. I have watched a genuinely brilliant piece of analysis get a lukewarm reception because it was ugly, and a fairly ordinary dashboard get praised because it looked polished. Not fair, but real.

For Australian businesses running Power BI at any scale, especially those with a brand to protect or reports that go to customers, board members, or the public, this is worth getting right. And it is cheap to get right if you do it early.

What a theme actually controls

A Power BI theme is, under the hood, a JSON file. You can apply built-in themes from the ribbon, tweak them through the theme customiser dialog, or write the JSON directly for full control.

At the simple end, a theme sets your data colours: the palette Power BI cycles through when it draws charts. This alone solves the "why is this bar orange and that one purple" problem, because everyone building reports draws from the same defined set.

Go a bit further and a theme controls the structural colours too. The colour for the first data point, colour for negative values, colours used in conditional formatting, background and foreground shades. This is where you encode the "red means bad" logic at the organisation level so nobody has to remember it.

At the detailed end, a theme can style specific visual types. You can set the default font, text size, and colour for titles. You can define how cards look, how tables are formatted, what the default gridlines do. Essentially you can push a huge amount of formatting into the theme so that a report author drops a visual on the canvas and it already looks right, with no manual formatting at all. That last part is the real prize and the part almost nobody uses.

How we roll themes out for clients

When we set up Power BI properly for a client, a theme is one of the first things we build, not an afterthought. And we build it from the brand, not from whatever colours look nice that day.

The starting point is the organisation's actual brand palette. Primary colour, secondary colours, the neutrals. We pull the real hex values from the brand guidelines, not an approximation someone eyeballed. Then we think about accessibility, because a lot of brand palettes were designed for a logo on a white background, not for a dashboard packed with small coloured data points sitting next to each other. Brand colours often need adjusting or supplementing so that charts stay readable and colour-blind users are not left guessing. This tension between "on brand" and "actually readable in a chart" comes up on almost every job.

Then we build the JSON theme file and, crucially, we treat it as a shared asset. It lives in a known place, it is version controlled, and when a new report starts, applying the corporate theme is step one. Not step forty-five when someone notices the colours are wrong. This is the difference between theming that sticks and theming that quietly rots. If the theme is a file on one person's laptop, it is dead within a month.

We also document it. A one-page note that says "here is the theme, here is where it lives, here is how to apply it, here is who owns changes to it." Boring, but it is the difference between a theme that survives staff turnover and one that gets forgotten the moment its creator leaves.

This kind of structured setup is exactly what our Power BI consultants do when we help an organisation move from ad hoc reporting to something that scales. The theme is a small part of that, but it is a telling one, because a team with a shared, enforced theme is usually a team that has its reporting act together generally.

The JSON is powerful and a bit of a pain

Honest bit. The theme JSON is genuinely powerful, and it is also fiddly.

The visual customiser dialog in Power BI Desktop is fine for colours and basic settings. But the moment you want to control the detailed per-visual styling, you are hand-editing JSON, and the schema is large, not brilliantly documented in places, and easy to get subtly wrong. A misplaced property does not always throw an obvious error, it just silently does nothing, and you are left wondering why your table styling is not applying. I have lost more time than I would like to admit to a typo'd property name that Power BI simply ignored.

My honest advice is to not over-engineer it on day one. Get the data colours and the structural colours right, because those deliver most of the value and the consistency people actually notice. The deep per-visual styling is worth doing once you have a stable set of report patterns, but chasing it too early, before you even know what your standard visuals are, is effort spent polishing something that is still changing shape.

The other thing to watch is theme versus manual overrides. A theme sets defaults, but a report author can always override any of it on an individual visual. That flexibility is good, but it means a theme does not enforce anything, it just sets a starting point. If someone wants to make a chart bright pink, the theme will not stop them. So themes reduce inconsistency, they do not eliminate the possibility of it. You still need a bit of culture and the occasional review to keep people from wandering off. Themes are a strong nudge, not a lock.

Where themes fit in the bigger picture

Theming feels like a small formatting feature, and on its own it is. But it points at something larger, which is treating your reporting as a proper product rather than a pile of individually crafted one-offs. A shared theme, shared datasets, agreed naming, documented ownership. These are the things that separate a reporting environment that scales from one that becomes an unmaintainable sprawl nobody trusts.

We see this constantly. An organisation gets excited about Power BI, everyone starts building, and eighteen months later there are hundreds of reports, no consistency, duplicated logic everywhere, and a nagging sense that half the numbers disagree with each other. Theming will not fix all of that, but the discipline that produces a good shared theme is the same discipline that produces a healthy reporting estate overall. If you get the theme habit right, you have usually got the other habits right too.

And as reporting increasingly connects to AI and natural language layers across the Microsoft stack, the clean, consistent, well-structured reports are the ones that play nicely with those layers. Consistency helps both the humans and the machines reading your data. If you are thinking about reporting as part of a broader data and AI plan rather than a scattering of dashboards, that is a strategy conversation, and it is the kind of thing our business AI strategy work exists to sort out.

Where I would start

If you have an existing pile of inconsistent reports, do not try to retrofit a theme onto all of them at once. That way lies misery. Build a proper theme, apply it to new reports going forward, and reformat the old ones opportunistically when you are touching them for other reasons. The estate converges over time without a big-bang project nobody signed off on.

If you are earlier in the journey, build the theme now, while you have five reports instead of five hundred. Pull your real brand colours, adjust them for chart readability, save the JSON somewhere shared, and make applying it the default first step for every new report. It costs you an afternoon and it saves you the slow, embarrassing sprawl that so many organisations end up living with.

Report themes are a small feature that quietly signals whether an organisation takes its reporting seriously. If you want Power BI reporting that looks consistent, stays on brand, and actually scales past the first dozen dashboards, that is very much the sort of thing we do. Have a look at our data and analytics services or get in touch and we will take a look at what you have got.