Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Import Font in Power BI

Cody Schneider••9 min read

Tired of Power BI’s default font selection? Forcing all your beautiful data into the creative confines of Segoe UI or Arial can feel limiting, especially when you need reports to match your company's established brand identity. This guide will walk you through exactly how to import and use custom fonts in your Power BI reports using a theme file, giving your dashboards a professional, branded finish.

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

Why Bother with Custom Fonts in Power BI?

While it might seem like a small detail, the fonts you use in your reports have a significant impact on your audience. Using custom fonts isn’t just about aesthetics, it’s about communication and professionalism. Here are the three main reasons to make the switch:

  • Brand Consistency: Your company likely has a style guide that specifies fonts used in marketing materials, on your website, and in presentations. Using those same fonts in your Power BI dashboards creates a seamless, professional experience and reinforces your brand identity. It makes the report instantly recognizable as part of your organization.
  • Improved Readability and Accessibility: Not all fonts are created equal. Some custom fonts are specifically designed for screen readability, with clearer distinctions between characters and better spacing. Choosing a font that is easy on the eyes can help your audience understand the data more quickly and reduce cognitive strain, especially in dense reports.
  • Enhanced Visual Appeal: Let's be honest - styling matters. A well-chosen font can make a dashboard look more polished and thoughtfully designed. It can help draw attention to key metrics, create a clear visual hierarchy, and transform a generic-looking report into a compelling, custom-built analytics tool.

The Foundation: Understanding Power BI Theme Files

Unlike some other applications, Power BI doesn’t have a simple “Upload Font” button. The secret to using custom fonts lies within a JSON theme file. If you've never heard of JSON, don't worry. A JSON (JavaScript Object Notation) file is just a lightweight, plain-text file used to store and exchange data. For our purposes, it's a cheat sheet that tells Power BI exactly how to style every visual element in a report.

Instead of manually changing the font family, font size, and color for every single chart title, table header, and data card, you can define everything one time in a JSON file. When you import this file, Power BI applies those rules across your entire report instantly.

This method is powerful because it allows for granular control over:

  • Color palettes (backgrounds, data colors, etc.)
  • Visual properties (borders, transparency, spacing)
  • And, most importantly for us, font styles for every text element.

By editing this single file, you ensure every last text element in your report aligns with your branding goals.

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-by-Step: Adding Custom Fonts to Your Power BI Report

Ready to get started? This process involves three core steps: installing the font on your local machine, creating a simple JSON file, and then importing that file into Power BI Desktop. Let’s break each one down.

Step 1: Install the Font on Your Computer

This is the most critical and often overlooked step. Power BI Desktop cannot use a font that is not installed on the system it's running on. If you don't do this, nothing else will work.

First, obtain your font file, which will typically be in a .TTF (TrueType Font) or .OTF (OpenType Font) format.

  • On Windows: Right-click the font file and select Install for the current user, or Install for all users if you have administrative rights. You can also open the 'Font settings' via the Start Menu and drag-and-drop your font file into the designated area.
  • On Mac: Double-click the font file. The Font Book application will open, showing a preview of the font. Click the Install Font button at the bottom of the window.

Important Note: You need to remember the font's official name. To find it, open a program like Microsoft Word or check your system's font folder. For example, the file might be named Montserrat-Bold.ttf, but its official system name is simply "Montserrat." This exact name is what you will need for the next step.

Step 2: Create or Update Your JSON Theme File

Now it's time to tell Power BI which font to use. To do this, you’ll create a simple text file and save it with a .json extension. You can use any basic text editor like Notepad on Windows, TextEdit on Mac, or a more advanced one like VS Code.

Creating a New Theme File

If you don't already have a custom theme, you can create a new .json file from scratch. Open your text editor, copy the code snippet below, and paste it into the new file.

{
  "name": "My Custom Brand Theme",
  "visualStyles": {
    "*": {
      "*": {
        "*": [
          {
            "fontFamily": "Poppins",
            "fontSize": 12,
            "color": { "solid": { "color": "#252423" } }
          }
        ],
        "labels": [
          {
            "fontFamily": "Poppins"
          }
        ],
        "title": [
          {
            "fontFamily": "Poppins SemiBold",
            "fontSize": 14
          }
        ],
        "categoryLabels": [
          {
             "fontFamily": "Poppins"
          }
        ],
        "calloutValue": [
        {
             "fontFamily": "Poppins"
        }
    ]
      }
    }
  }
}

Here’s what this code does:

  • "name": "My Custom Brand Theme" simply gives your theme a name that will appear in Power BI.
  • The "*" asterisks are wildcards. By nesting them, we are creating a very general rule: "Apply these styles to all visuals (*), impacting all their properties (*), for all object types (*)". This is the easiest way to set a global default.
  • "fontFamily": "Poppins" is the key part. Replace "Poppins" with the exact name of the custom font you installed. If your font has different weights (e.g., Bold, Light, SemiBold), you can specify those here too, like "Poppins SemiBold". Make sure the font weight is also installed on your system.
  • We’ve also defined specific styles for components like "title" and "labels" to show you how you can get more specific. Power BI will apply the most specific rule it can find.

After pasting and modifying the code, save the file. Remember to change the file extension from .txt to .json. For example, name it my-brand-theme.json.

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

Step 3: Import the Theme into Power BI Desktop

With your font installed and your JSON file saved, the final step is to bring it all into Power BI.

  1. Open your Power BI report (.pbix file) in Power BI Desktop.
  2. Navigate to the View tab in the main ribbon at the top of the window.
  3. In the Themes section, click the small dropdown arrow to reveal more options.
  4. Select Browse for themes from the bottom of the list.
  5. A file browser window will appear. Navigate to where you saved your .json theme file and select it.
  6. Click Open.

As soon as you do this, Power BI will apply the theme. You should see all the text elements in your report change instantly to your custom font. If nothing happens, or if it doesn't look right, don't panic! Check the troubleshooting section below.

Common Issues and Best Practices

Importing custom fonts can sometimes be tricky. Here are a few common stumbling blocks and how to navigate them.

Font Name Mismatches

The most common error is a mismatch between the fontFamily name in your JSON file and the font's actual system name. If you use "Roboto-Bold" in your code when the system knows it as "Roboto" with a bold property, it won't work. The best way to check the correct name is to open an application like Microsoft Word or PowerPoint, find the font in the dropdown list, and use that exact spelling in your JSON file.

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.

Distribution and The Power BI Service

This is a major consideration. Custom fonts are not embedded into the report file when you publish to the Power BI Service. This means if you publish your report online and share it with colleagues, they will only see your custom font if they also have that exact font installed on their own computers.

If a viewer does not have the font installed, Power BI will default to a fallback font, usually Segoe UI. This can sometimes cause formatting issues, like text overflowing its container. For this reason, if you're distributing a report widely to an audience outside your organization, it's often safer to stick with web-safe fonts or ensure your organization's IT department deploys the custom font to all company machines via policy.

My Font Isn't Showing Up at All!

If you've imported the theme and nothing has changed, here's a quick checklist:

  1. Restart Power BI Desktop: Sometimes, Power BI needs to be restarted after a new font is installed. Close and reopen the application and try importing the theme again.
  2. Check Your JSON Syntax: One missing comma or curly brace can invalidate the entire JSON file. Use an online JSON validator to paste your code and check for errors.
  3. Confirm Font Installation: Double-check that the font appears in other applications on your computer. If it’s not there, it’s not properly installed.

Final Thoughts

Using custom fonts in Power BI is a powerful way to elevate your reports from standard templates to polished, on-brand analysis tools. While it requires using a JSON theme file instead of a simple button, the process provides you with total control over your report's appearance, ensuring consistency and professionalism in everything you build.

Manual data wrangling and report styling in complex tools can take hours away from an already busy week. What if you could spend that time on strategy instead? This is why we built Graphed to help. You can connect your marketing and sales data sources in just a few clicks and build real-time dashboards simply by describing what you want to see in plain English. We turn hours of complex work into a few seconds, letting you create dashboards on the fly, ask follow-up questions, and get valuable insights without wrestling with complex builders or custom code. If you’re ready to get your time back, check out Graphed and start building better reports in minutes.

Related Articles