March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
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"
}
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
147 | |
92 | |
70 | |
58 |