The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?