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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I would need to create a json file in which I would like to extend the "Arial" font for each element of my dashboard (filters, tables, charts, pivots, etc.), especially including the subtotals of the matrix (pivots), that seems to be not included when I use my JSON file. In fact that's good for all but not for subtotals of Matrix:
{
"name": "CustomFont",
"visualStyles": {
"*": {
"*": {
"*": [
{
"fontSize": 10,
"fontFamily": "Arial",
"fontWeight": "bold",
}
]
}
}
}
}
How can I do? Could you send me the correct Json?
Thank you!
Hi @CrgJnr ,
Please update the codes as below and check if it can return the expected result...
{
"name": "CustomFont",
"visualStyles": {
"*": {
"*": {
"*": [
{
"fontSize": 10,
"fontFamily": "Arial",
"fontWeight": "bold"
}
]
}
},
"pivotTable": {
"*": {
"subTotals": [
{
"rowSubtotals": true,
"columnSubtotals": true,
"fontColor": {
"solid": {
"color": "#332222"
}
},
"fontFamily": "Arial",
"fontSize": 10,
"fontWeight": "bold",
"backColor": {
"solid": {
"color": "#01B8AA"
}
},
"applyToHeaders": true,
"rowSubtotalsPosition": "Bottom",
"perRowLevel": true,
"perColumnLevel": true
}
]
}
}
}
}
In addition, you can refer the following link from Github to get it.
PowerBI-ThemeTemplates/Matrix.json at master · MattRudy/PowerBI-ThemeTemplates · GitHub
Best Regards
No idea please?