Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
bmcminn
Helper II
Helper II

Two-fer. More than 8 colors, custom font?

Hello. These are probably perennial questions, but I can't find anything recent on them.

1) I'm building a custom theme and would like to load more than 8 colors to use for visualizations. I haven't even found a workaround for this.

 

2) I'm wondering if there is a way to load a custom font. I know that I can specify the font in the .json file, but that relies on the font being loaded onto the machine for the person reading the report. This report will be loaded and emebeded for an enterprise and we need to ensure consistent styling.

Thanks

4 REPLIES 4
Joris_NL
Helper II
Helper II

About the maximum of 8 colors in the JSON file, it's very sensitive to spaces/tabs when you edit the file. But yes you can add more. In fact one of Microsofts examples has 10 colors: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes#set-theme-colors 

You can expand those but be sure to use tabs and not spaces.

{
    "name": "Custom Theme",
    "dataColors": [
        "#118DFF",
        "#12239E",
        "#E66C37",
        "#6B007B",
        "#E044A7",
        "#744EC2",
        "#D9B300",
        "#D64550",
        "#197278",
        "#1AAB40"
    ],
    "good": "#1AAB40",
    "neutral": "#D9B300",
    "bad": "#D64554",
    "maximum": "#118DFF",
    "center": "#D9B300",
    "minimum": "#DEEFFF",
    "null": "#FF7F48"
}
TheoC
Super User
Super User

Hi @bmcminn 

 

You should be able to do that by modifying the JSON by using this approach: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes#set-theme-colors

 

In terms of adding font, you can do this: https://community.powerbi.com/t5/Desktop/Add-a-font/m-p/256308

 

All the best!

 

Theo 🙂

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

I already tried both of these. You can not add more than 8 colors plus black and white. Even if you add more to the .json file.

I do not think a font is not loaded into the report. It has to be on the users system. At least when I checked the other week. I believe the discussion page you reference mentions that.

Unfortunately I have the same issue. Only 8 colors althought adding more in .jason file.
The font selection in Piwer BI seems also to be limited to fewer that in the other office apps like Word, Excel and Power Point.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.