Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Import Theme in Power BI

Cody Schneider••8 min read

Tired of manually changing colors and fonts on every new Power BI report to match your company's branding? Importing a theme is a quick and effective way to apply consistent, professional styling across all your dashboards. This guide will walk you through exactly what themes are, how to import them, and even how you can create your own from scratch.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

What Exactly is a Power BI Theme?

Think of a Power BI theme as a style guide for your reports. It’s a single file that tells Power BI how to format every visual element, ensuring a consistent look and feel. Instead of setting the color for every bar in a chart or a header's font size one by one, a theme applies all those rules for you automatically.

This file is written in a format called JSON (JavaScript Object Notation), but you don’t need to be a developer to use one. A theme file can define a wide range of properties, including:

  • Color Palettes: A set of primary and secondary colors that your charts and graphs will automatically pull from.
  • Font Styles: The default font family, size, and color for titles, labels, cards, and other text elements.
  • Visual Properties: Specific settings for different chart types, such as background colors, borders, and data label placement.
  • Page & Wallpaper: The default background colors or images for your report pages and the wallpaper area around them.

Why You Should Be Using Themes

Using themes isn't just about making your reports look pretty, it's about being efficient and maintaining professional standards. Here are the core benefits:

  • Save Time and Effort: This is the biggest win. Once you have a theme, you can apply it to any new report with a few clicks. You’ll no longer waste time tweaking individual visual settings over and over again.
  • Ensure Brand Consistency: For businesses, this is crucial. A theme ensures every report produced, regardless of the creator, aligns perfectly with the company's official brand guidelines. All your charts will use the same brand colors, and all text will use the approved fonts.
  • Improve Readability and Professionalism: A well-designed theme improves the user experience. By standardizing your design choices, you create reports that are easier to read and interpret. A clean, professional look also builds trust in the data you're presenting.

How to Import a Theme in Power BI: A Step-by-Step Guide

Ready to apply a theme? The process is remarkably straightforward. All you need is a theme's JSON file saved somewhere on your computer. If you don’t have one yet, you can find pre-made themes in the Power BI Community Theme Gallery or use one of the built-in themes to start.

Here’s how to do it in Power BI Desktop:

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 1: Open the Themes Menu

Navigate to the View tab on the Power BI ribbon at the top of the application. Here, you'll see a section called "Themes." Click the arrow on the right side of the Themes gallery.

This menu shows you the current theme styles available. You'll see the default options that come with Power BI and might see a few others if they have been added before.

Step 2: Browse for Your Theme File

At the bottom of the dropdown menu, click on Browse for themes. This will open a standard file explorer window, allowing you to navigate your local computer.

Step 3: Select and Open Your JSON File

Locate the .json theme file you want to use. You might have downloaded it from a community site or created it yourself. Select the file and click Open.

Step 4: Watch Your Report Update

Power BI will instantly apply the theme to your entire report. You'll see "Theme successfully imported" at the top of your report when done successfully. All your existing visuals — charts, tables, cards, and slicers — will update to reflect the new colors, fonts, and settings defined in the JSON file. It's that simple!

What If I Want to Create My Own Theme?

Sometimes, a pre-built theme doesn’t quite fit your needs. The good news is that creating your own custom Power BI theme is easier than you might think. You have two main options: writing the JSON file yourself or using an online theme generator.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Option 1: Manually Creating the JSON File

A Power BI theme is just a plain text file, which you can create in any simple text editor like VS Code, Notepad, or TextEdit on a Mac. You’ll save it with a .json extension.

A very basic theme file looks like this:

{
    "name": "My Custom Brand Theme",
    "dataColors": [
        "#003f5c", 
        "#58508d", 
        "#bc5090", 
        "#ff6361", 
        "#ffa600"
    ],
    "background": "#FFFFFF",
    "foreground": "#333333",
    "tableAccent": "#003f5c"
}

Let’s break down what this does:

  • name: This is the name your theme will have when you hover over it in Power BI.
  • dataColors: This is a list of color hex codes. Power BI will cycle through these colors for series in your charts (e.g., the different bars in a bar chart).
  • background, foreground, tableAccent: These define base colors for the report. background is for shapes, foreground is for text, and tableAccent is for elements in tables and matrices.

Going Deeper with Visual Styles

The real power of themes comes from customizing individual visual properties. You can add a visualStyles block to your JSON to control specific visual types.

For example, what if you wanted every card visual to use a specific font size and color? You would add this to your file:

"visualStyles": {
    "card": {
        "*": {
            "labels": [{
                "color": { "solid": { "color": "#58508d" } },
                "fontSize": 14
            }],
            "categoryLabels": [{
                "color": { "solid": { "color": "#333333" } },
                "fontSize": 12
            }]
        }
    }
}

The asterisk (*) is a wildcard that applies the settings to all states of the card visual. While going through every possible setting is beyond this article, you can control almost anything, from axis labels on your bar charts to border styles on your matrices. For a complete list of customizable elements, refer to the official Microsoft documentation on theme JSON structure.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Option 2: Using a Theme Generator

If writing JSON code feels intimidating, you're not alone. Thankfully, there are free online tools to help. One of the most popular is the theme generator from PowerBI.tips.

These generators provide a user-friendly interface where you can:

  • Pick your primary and secondary colors using color pickers.
  • Select default fonts and text sizes from dropdown menus.
  • Preview how your theme will look in real-time.

Once you are happy with your design, you just click a button to download the perfectly formatted .json file, ready for you to import into Power BI Desktop.

Best Practices for Using Power BI Themes

Now that you know how to import and create themes, here are a few tips to make your reports even better.

  • Focus on Accessibility: Design isn't just about brand colors, it's about making your data understandable for everyone. Use web tools like contrast checkers to ensure your font colors are clearly visible against their backgrounds. Avoid relying solely on color to convey information — use labels and clear titles.
  • Less is More: It’s tempting to use every color in your brand palette, but a clean, simple report is almost always more effective. Stick to a few primary colors for data and use neutral grays for backgrounds, axes, and secondary text. Let the data be the star.
  • Test Extensively: Apply your new theme to a report that has a wide variety of visuals — bar charts, line charts, KPIs, cards, tables, maps, and slicers. This helps you identify any unexpected formatting issues, like text becoming unreadable or chart legends looking odd.
  • Create a Report Template: The ultimate time-saver is creating a Power BI Template file (.pbit). Start a new, blank Power BI project, import your custom theme, and then go to File > Save As. Change the file type to "Power BI template (.pbit)". Now, whenever you start a new report from this template, your theme will already be loaded and ready to go.

Final Thoughts

Importing themes in Power BI is a fundamental skill for anyone who wants to create polished, professional, and consistent reports efficiently. Whether you use a community-built theme, a simple JSON file, or an online generator, you can elevate your data storytelling and save yourself countless hours of manual formatting work.

While Power BI themes are fantastic for styling reports, what if you could automate the entire creation process? At Graphed, we focus on helping you get from raw data to actionable insights in seconds. Instead of wrestling with visual configurations, you can use simple, natural language to ask questions like "Show me my sales by region this quarter" and we instantly build a live, interactive dashboard for you, completely eliminating the time spent on manual setup and styling. All of our AI-generated dashboards are easy to embed, meaning you can get beautiful reports without any developer assistance or BI expertise.

Related Articles