Add corporate font to Power BI Desktop report

Debra Kloth

I thought I'd share how to add the Blackbaud Sans font to Power BI Desktop for use in internal reports and dashboards published to Power BI Service. Until we test it out with an external client I cannot confirm that the Blackbaud Sans font will carry over into a client's reports/dashboards without the font set being installed on the client's machine.

Here's how to add it to our internal reports:

In Power BI Desktop, open the report canvas. Go to View and select a Theme that you want to use as a starting point for your report.

Expand the carat on the right to expand the Themes pane. Scroll down and select Save Current Theme. Rename the file and save it to your computer, network drive - it doesn't matter where. Power BI saved the file as a JSON file which you can edit in Notepad or Word Pad. I downloaded the Accessible City Park theme JSON file:

Before the last curly bracket, insert this code:

,"visualStyles":{"*":{"*":{"*":[{"fontSize":12,"fontFamily":"Blackbaud Sans","color":{"solid":{}}}]}}}

Substitute your corporate font name in place of Blackbaud Sans.

Your JSON should look like this:

Save the JSON file. In Power BI Desktop, open the Themes pane again. Click on Browse for Themes. Navigate to the JSON file that you just edited to include the corporate font. The theme will import.

Voila! Blackbaud Sans:

This post shows how to apply Blackbaud Sans font size 10 to every report element. Theme files can be expanded to become very detailed with, for example, different fonts, font sizes and font colors for each graph axis, each axis title and the graph title.

Source: