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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
fguiroy
New Contributor

Issues with report themes in Power BI Desktop

Hi everyone!

 

I'm trying to change the font of a matrix in PowerBI with "Noto Sans Medium" that doesn't come as a native option for PowerBI.

I reviewed all the Documentation and was able to find a couple of .JSON that works for almost all the report except the Matrix visualization and a pie chart.

This are the two options that i was trying to implement, but none of them are working.

The first one should affect the entire dashboard. The only exception are the visualizations ->

{
    "name": "Custom Theme",
    "textClasses": {
        "callout": {
            "fontSize": 30,
            "fontFace": "Noto Sans Medium",
            "color": "#252423"
        },
        "title": {
            "fontSize": 12,
            "fontFace": "Noto Sans Medium",
            "color": "#252423"
        },
        "header": {
            "fontSize": 12,
            "fontFace": "Noto Sans Medium",
            "color": "#252423"
        },
        "label": {
            "fontSize": 10,
            "fontFace": "Noto Sans Medium",
            "color": "#252423"
        }
    }
}

The second one it's pretty specific about matrix, but it doesn't work neither.

{
    "name": "MatrixTemplate",
    "visualStyles": {
        "pivotTable": {
            "*": {
                    "stylePreset":[{
                                "name":"Default"
                            }],
                    "grid": [{
                    "gridVertical": true,
                    "gridVerticalColor": { "solid": { "color": "#FFB8DD"}},
                    "gridVerticalWeight": 2,
                    "gridHorizontal": true,
                    "gridHorizontalColor": { "solid": { "color": "#FFB8DD"}},
                    "gridHorizontalWeight": 2,
                    "rowPadding": 1,
                    "outlineColor": { "solid": { "color": "#FFB8DD"}},
                    "outlineWeight": 2,
                    "textSize": 14,
                    "imageHeight": 100
                }],
                "columnHeaders": [{
                    "fontColor": { "solid": { "color": "#00B8DD"}},
                    "backColor": { "solid": { "color": "#00AA22"}},
                    "outline": "Frame",
                    "autoSizeColumnWidth": true,
                    "fontFamily": "Noto Sans",
                    "fontSize": 10,
                    "alignment": "Left",
                    "titleAlignment": "Right",
                    "urlIcon": true,
                    "wordWrap": true
                }],
                "rowHeaders": [{
                    "fontColor": { "solid": { "color": "#00B8DD"}},
                    "backColor": { "solid": { "color": "#00AA22"}},
                    "outline": "Frame",
                    "stepped": true,
                    "steppedLayoutIndentation": 12,                 
                    "urlIcon": true,
                    "wordWrap": true,
                    "fontFamily": "Noto Sans",
                    "fontSize": 10,
                    "alignment": "Left", 
                    "showExpandCollapseButtons":true
                }],
                "values": [{
                    "fontColorPrimary": { "solid": { "color": "#00B8DD"}},
                    "backColorPrimary": { "solid": { "color": "#00AA22"}},
                    "fontColorSecondary": { "solid": { "color": "#FFB8DD"}},
                    "backColorSecondary": { "solid": { "color": "#FFAA22"}},
                    "bandedRowHeaders": true,
                    "valuesOnRow": true,
                    "outline": "Frame",
                    "urlIcon": true,
                    "wordWrap": true,
                    "fontFamily": "Noto Sans",
                    "fontSize": 10
                }],
                "subTotals": [{
                    "rowSubtotals": true,
                    "columnSubtotals": true,
                    "fontColor": { "solid": { "color": "#332222"}},
                    "fontFamily": "Noto Sans",
                    "backColor": { "solid": { "color": "#01B8AA"}},
                    "fontSize": 10,
                    "applyToHeaders": true,
                    "rowSubtotalsPosition": "Bottom",
                    "perRowLevel": true,
                    "perColumnLevel": true                  
                }],
                "total": [{
                    "fontColor": { "solid": { "color": "#00B8DD"}},
                    "fontFamily": "Noto Sans",
                    "backColor": { "solid": { "color": "#00AA22"}},
                    "applyToHeaders": true,
                    "fontSize": 10
                }]
            }
        }
    }
}

Does anybody knows if you can add a font that's not included in PowerBI in the visualizations ?

Thanks!

0 REPLIES 0

Helpful resources

Announcements
Users online (2,086)