How to Import JSON Theme File in Power BI

Tired of manually changing the colors, fonts, and sizes for every single visual in your Power BI reports? Applying your company’s branding to a dashboard shouldn't take longer than building the analysis itself. Luckily, there’s a fast and simple way to get brand-perfect, consistent reporting every single time with theme files.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

This article will show you exactly how to import and use a JSON theme file in Power BI. We’ll cover what themes are, why they are a massive time-saver, and the step-by-step process for getting them working in your reports today.

What is a Power BI Theme, Exactly?

Think of a Power BI theme like a style guide or a template for your reports. It’s a single file that tells Power BI exactly how you want your visuals to look - your brand colors, your preferred fonts, the size of titles, whether visuals should have borders, and dozens of other formatting options.

This "style guide" is written in a language called JSON (JavaScript Object Notation) and is saved in a file with a .json extension. Instead of clicking through endless formatting panes to manually change the color of every bar chart, the title font of every table, and the background of every card visual, you can apply all those rules at once by importing this one file.

A theme file can control a huge range of properties, including:

• Data Colors: The sequence of colors used in charts, graphs, and other visuals. This is the most common use case - ensuring all charts use your official brand color palette.
• Text and Font Properties: The font family, size, and color for titles, labels, cards, and KPIs.
• Visual Styles: Background colors, borders, headers, and tooltips for all your visuals.
• Page & Wallpaper: The default background color or image for your report pages.

Why You Should Be Using Power BI Themes

If you're creating more than one report or dashboard, using themes isn't just a "nice-to-have", it’s essential for working efficiently and professionally. The benefits go far beyond just saving a few clicks.

Enforce Brand Consistency

Your reports are a representation of your business. When you share a dashboard with stakeholders, clients, or executives, you want it to look official and polished. A Power BI theme ensures that every single report your team produces adheres to your company's branding guidelines, from the exact hex code for your primary blue to the specific font used in headers. This instantly makes your analytics work feel more credible and integrated with the rest of your company's materials.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Save Massive Amounts of Time

Let's be honest: formatting is tedious. Calculate the time you spend on every new report just getting the colors right, adjusting font sizes, and adding consistent borders. Maybe it's 15 minutes, maybe it's 30. Now multiply that by the number of reports you build each month.

With a Power BI theme, this process takes about 10 seconds. You import the file once per report, and every visual - both existing and new - automatically adopts the correct formatting. It’s one of the single biggest productivity boosts for any regular Power BI user.

Improve Report Readability and Accessibility

A well-designed theme is about more than just branding, it's about clarity. Good themes are created with the end-user in mind. They use high-contrast colors that make charts easy to read, standardized font sizes that guide the eye logically through the page, and subtle visual cues like borders to neatly organize information. This leads to more effective dashboards where users can find insights faster instead of getting lost in a sea of clashing colors and inconsistent text.

Maintain Standards Across a Team

What happens when multiple people are building reports? Without a theme, you get chaos. One person likes using shadow effects, another prefers a different header font, and a third just uses the default colors. The result is a messy collection of reports that look like they came from different companies.

A shared theme file completely solves this. It acts as the single source of truth for all report designs, ensuring that whether a dashboard is built by Jane in Marketing or John in Sales, it will have the same professional look and feel.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding the Basic JSON Structure

You don't need to be a developer to use a theme file, but seeing what's inside can help you understand how it works. A Power BI theme file is a text file that contains key-value pairs to define formatting properties.

Here’s a very simple example of what the JSON code inside a theme file might look like:

{ "name": "My Company Brand Theme", "dataColors": [ "#003f5c", "#58508d", "#bc5090", "#ff6361", "#ffa600" ], "visualStyles": { "": { "": { "title": [{ "fontFamily": "Segoe UI Bold", "fontSize": 14, "color": { "solid": { "color": "#222222" } } }], "border": [{ "show": true, "color": { "solid": { "color": "#CCCCCC" } }, "radius": 5 }] } } } }

Let's break that down:

• "name": This is simply the name of your theme.
• "dataColors": This is a list of color hex codes. Power BI will cycle through these colors in order for your charts.
• "visualStyles": This is where you set properties for all visuals. The asterisk (*) is a wildcard that means "apply this to all visuals."
• "title": Inside the visual styles, we are defining properties for the title of every visual. Here, we've set a specific font, size, and color.
• "border": We’re also telling every visual to show a light gray border with slightly rounded corners (a radius of 5).

Even this simple theme automates half a dozen manual steps for every single chart you create!

Where to Find or Create Power BI Themes

So, where do you get one of these powerful JSON files? You have several options, ranging from simple and ready-to-use to fully custom.

1. Use Power BI’s Built-in Themes

The easiest place to start is right inside Power BI Desktop. In the View tab, you'll find a gallery of pre-built themes. These are great for quickly changing the entire look and feel of a report, and you can see the results instantly.

2. Download from the Power BI Theme Gallery

For more options, you can explore the official Power BI Community Themes Gallery. Here, users and Power BI experts share themes they’ve created. You can often find professionally designed, accessible themes that you can download and use for free.

3. Use an Online Theme Generator

Several free tools exist online that let you visually build a theme without writing any code. Tools like PowerBI.Tips Theme Generator and Color B. Furnace let you pick your colors and fonts, and they will generate the .json file for you to download automatically. This is the best option for creating a custom brand theme without needing to learn JSON syntax.

4. Build Your Own From Scratch

For ultimate control, you can write your own JSON file in a simple text editor like VS Code or even Notepad. You can start with a simple file like the example above and gradually add more properties. Microsoft provides comprehensive documentation on all the properties you can use.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step: How To Import Your JSON Theme File

Once you have your .json theme file ready, applying it to a report takes just a few clicks. Follow these simple steps:

Step 1: Save Your JSON File Ensure your theme file is saved somewhere easy to find on your computer, with the extension .json.

Step 2: Open Power BI Desktop Launch Power BI Desktop and open the report you wish to apply the theme to.

Step 3: Navigate to the "View" Tab In Power BI Desktop, click on the "View" tab in the ribbon.

Step 4: Click the "Themes" Button In the "View" tab of the ribbon, you'll see a section for themes.

Step 5: Select "Browse for Themes" From this menu, find the "Browse for Themes" option and select it.

Step 6: Locate and Open Your JSON File Find the location where your JSON file is saved, select the file, and click "Open."

Step 7: Apply Your Theme After selecting the file, Power BI will automatically apply your theme, and you can see the changes instantly across the report.

Final Thoughts

Using JSON themes is one of the most effective ways to elevate your Power BI reports from functional to professional. It saves you an enormous amount of time, creates a consistent and trustworthy brand experience, and ultimately lets you focus more on generating insights rather than getting stuck on formatting details.

For teams that find Power BI's setup for things like this a bit complex or time-consuming, the entire reporting process can still feel like a chore. Sometimes you just need answers without spending time writing JSON or navigating configuration menus. At Graphed, we’ve removed that friction by enabling you to build dashboards directly in natural language. Instead of manually creating visuals and reports, you just describe what you want to see - "Show me a dashboard of ad spend vs revenue by campaign" - and we build it for you in seconds with your live data sources connected, saving you from the hands-on building process altogether.