A simpler way to ship Power BI and Excel themes.
pwrtheme is a visual theme builder for Power BI and Excel. Pick colors, adjust typography, preview every change live, and download a schema-valid theme.json for Power BI Desktop, or an Excel template and chart templates for Excel. Or set your brand's colors and fonts once and get both.
Why this exists
Power BI Desktop does let you customize an existing theme in-app, but the built-in editor only exposes a fraction of what the schema supports, and you can't see how your changes will look until after you apply them. The other route is hand-editing a long, loosely documented JSON file and reloading Power BI Desktop after every tweak.
pwrtheme was started to make it as easy as possible to get a complete, valid theme JSON without writing a single line by hand. You see everything in context as you build it, every field is mapped to the latest Microsoft schema, and the export is a clean file ready to import.
Excel has the same gap. Making a custom theme the default means building a template by hand, restyling each cell style and table style, and saving it as Book.xltx in a startup folder most people never see. The Excel builder shows the whole thing on a live workbook and gives you that template ready to use.
What you get
- A live Power BI report and Excel workbook that react to every change in real time
- Full control over data colors, with as many or as few as you need
- Schema-validated Power BI JSON, following Microsoft's official theme schema
- Excel templates with your theme colors, fonts, cell styles and table style
- Excel chart templates that keep following the workbook's theme
- A brand builder: set your colors and fonts once and get matching Power BI and Excel themes
- Your brand in PowerPoint and on the web too: a PowerPoint template, CSS variables, a Tailwind theme and chart themes
- A dashboard layout generator: lay out the page on a grid and get a Power BI background in your colors
- Your own font, with a fallback for people who don't have it
- Optional account to save themes, brands and layouts and open them on any device
- One-click download, with no copy-paste and no manual formatting
- Preview and customize your kit before signing in; an account is required to save and download
Who runs it
pwrtheme is owned and operated by Kent Roksvåg, a financial controller and owner of Roksvåg Consult, a Norwegian sole proprietorship based in Oslo.
It is built and maintained independently and is not affiliated with Microsoft. Power BI and Excel are trademarks of Microsoft Corporation.
Get in touch
Questions, feedback, or a feature request? Email informasjon@rates.no.