SF logo
Power BI toolkit

Theme Builder

Start from one brand color. The page builds the data palette, text, background, good and bad colors, and a full report theme with styles for every common visual (you can set titles, borders, legends and more for all visuals or one kind), checks it for readability and color blindness, and gives you the theme file to import. No AI needed.

Step1

Your brand colors

One color is enough. Add up to two more if your brand has them; the page fills the rest of the palette to match.

Already have a theme? Start from your theme file

Its colors and font fill the steps below, and its visual styles replace the built-in ones. What you change on this page is added on top. Or pick a PBIP report folder and the page finds the theme the report uses, and lists its visuals in Step 3.

Step2

Fine-tune

Change any data color. Don’t like a suggested one? Other options under it lists colors that fit instead. Then choose the page and visual backgrounds, text, good and bad colors and the font. Everything else in the theme follows from these.

Data colors (series colors, in order)

The ratio on each color is its contrast with the background it sits on: how much it stands out, from 1:1 (invisible) to 21:1 (black on white). 4.5:1 or more is readable as text, such as titles and labels. 3:1 to 4.5:1 is fine for bars, lines and slices, but too light for text. Under 3:1 is hard to see; keep it for big shapes or less important series.

Backgrounds and text

Report page (the canvas behind everything)
Visuals (charts, tables, cards and slicers)

Good, neutral and bad

Used for waterfall increases and decreases, KPI status, and conditional formatting. The default is the dark green, dark yellow and dark red text colors from Excel’s conditional formatting.

Combo chart bubble size

For a line and clustered column chart that shows a bubble with a label over each column. Power BI’s default marker is too small for that, so the theme sets it. Only markers you turn on change, and only in that chart type.

Step3

Visual settings

How visuals look when you add them. Start with the common settings for all visuals or one kind of visual. For more, copy the formatting of a visual from your own report, or set any property the theme file takes. Leave a setting as it is to keep the theme’s default.

All visuals

By kind of visual (these win over All visuals)

Copy settings from a visual

Format a visual the way you want in a sample report saved as a PBIP project. Read it here and its formatting becomes the theme’s default for that kind of visual, so every report with the theme gets it. Styles for hover and selected come too. Title text, and colors set for one series or by a field, stay behind; each visual says what was left out and why.

Or paste a visual.json

Every property

Every formatting option a theme file can set, for every visual, from Microsoft’s theme schema. What you set here wins over everything above. Leave a box empty to keep the theme’s value, shown in grey.

Your property changes

Step4

Preview

A sketch of a report page with the theme applied, to judge the colors together. Power BI’s own rendering will differ in detail.

Step5

Download and import

The theme file includes your colors, font, text styles, icons and formatting for 27 visual types and the page, with your visual settings from Step 3.

See the theme JSON

Use it in Power BI Desktop

  1. Open your report and select View > Themes > Browse for themes.
  2. Choose the downloaded file. Power BI applies it to every page straight away.
  3. To make it the starting point for new reports, save a blank report with the theme as a template (File > Export > Power BI template).