Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Good morning everyone. I'm experiencing a problem with importing a customized design in Power BI. I've created a short Json-file with color specifications but cannot import it in Power BI. I need to add more properties (font, font size) but even the simpliest one with colors doesn't work. That's my file:
{
"name": "HS",
"dataColors": ["#DA291C", "#FEC900", "#00965E", "#298FC2", "#B00000", "#595959", "#F9AD15", "#127D44", "#00759A", " #FE9A7A", "#999999", "#FFDC38", "#84BF62", "#74B1E8", "#000000"],
"foreground":"#000000",
"foregroundNeutralSecondary": "#000000",
"foregroundNeutralTertiary": "#000000",
"background":"#FFFFFF",
"tableAccent": "#000000"
}
Any help would be greatly appreciated!
Solved! Go to Solution.
Hi @Anonymous ,
>>I've created a short Json-file with color specifications but cannot import it in Power BI.
I think it should be related to your datacolor setting, it contains invailed hex color string " #FE9A7A":
"dataColors": ["#DA291C", "#FEC900", "#00965E", "#298FC2", "#B00000", "#595959", "#F9AD15", "#127D44", "#00759A", " #FE9A7A", "#999999", "#FFDC38", "#84BF62", "#74B1E8", "#000000"],
I modify your code and add font formatting part into the theme file:
{
"name":"My Theme",
"background":"#FFFFFF",
"foreground":"#000000",
"foregroundNeutralSecondary":"#000000",
"foregroundNeutralTertiary":"#000000",
"tableAccent":"#000000",
"dataColors":[
"#DA291C",
"#FEC900",
"#00965E",
"#298FC2",
"#B00000",
"#595959",
"#F9AD15",
"#127D44",
"#00759A",
"#FE9A7A",
"#999999",
"#FFDC38",
"#84BF62",
"#74B1E8",
"#000000"
],
"visualStyles":{
"*":{
"*":{
"*":[
{
"fontSize":12,
"fontFamily":"Arial"
}
]
}
}
}
}
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
>>I've created a short Json-file with color specifications but cannot import it in Power BI.
I think it should be related to your datacolor setting, it contains invailed hex color string " #FE9A7A":
"dataColors": ["#DA291C", "#FEC900", "#00965E", "#298FC2", "#B00000", "#595959", "#F9AD15", "#127D44", "#00759A", " #FE9A7A", "#999999", "#FFDC38", "#84BF62", "#74B1E8", "#000000"],
I modify your code and add font formatting part into the theme file:
{
"name":"My Theme",
"background":"#FFFFFF",
"foreground":"#000000",
"foregroundNeutralSecondary":"#000000",
"foregroundNeutralTertiary":"#000000",
"tableAccent":"#000000",
"dataColors":[
"#DA291C",
"#FEC900",
"#00965E",
"#298FC2",
"#B00000",
"#595959",
"#F9AD15",
"#127D44",
"#00759A",
"#FE9A7A",
"#999999",
"#FFDC38",
"#84BF62",
"#74B1E8",
"#000000"
],
"visualStyles":{
"*":{
"*":{
"*":[
{
"fontSize":12,
"fontFamily":"Arial"
}
]
}
}
}
}
Regards,
Xiaoxin Sheng
Thank you @Anonymous for your solution, it works now.
Best wishes,
Tanja
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 46 | |
| 42 | |
| 34 | |
| 31 | |
| 21 |
| User | Count |
|---|---|
| 134 | |
| 124 | |
| 98 | |
| 80 | |
| 65 |