Power BI JSON主题矩阵表行小计与列总计格式失效问题求助

问题描述 #

在创建Power BI JSON主题文件时，配置矩阵表遇到以下两个格式问题：

• 行小计（Row Subtotals）的格式设置未生效
• 列总计（Column Grand Total）无法实现Calibri 10号字体、applyToLabels=true的要求，行小计同样需要满足该配置

原主题代码 #

{
    "name": "Test",
    "pivotTable": {
        "*": {
            "stylePreset": [
                {
                    "name": "Default"
                }
            ],
            "grid": [
                {
                    "gridVertical": false,
                    "gridHorizontal": false,
                    "rowPadding": 4,
                    "outlineWeight": 2,
                    "textSize": 10
                }
            ],
            "columnHeaders": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#ffffff"
                        }
                    },
                    "backColor": {
                        "solid": {
                            "color": "#142640"
                        }
                    },
                    "outline": "None",
                    "outlineColor": {
                        "solid": {
                          "color": "#0e1622"
                        }
                    },
                    "outlineWeight": 1,
                    "autoSizeColumnWidth": true,
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "bold": true,
                    "alignment": "Left",
                    "titleAlignment": "Left",
                    "wordWrap": true
                }
            ],
            "rowHeaders": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "outline": "RightOnly",
                    "outlineColor": {
                        "solid": {
                          "color": "#0e1622"
                        }
                    },
                    "outlineWeight": 1,
                    "stepped": true,
                    "steppedLayoutIndentation": 10,
                    "wordWrap": true,
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "alignment": "Left",
                    "showExpandCollapseButtons": true
                }
            ],
            "values": [
                {
                    "fontColorPrimary": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "backColorPrimary": {
                        "solid": {
                            "color": "#ffffff"
                        }
                    },
                    "fontColorSecondary": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "backColorSecondary": {
                        "solid": {
                            "color": "#F4F4F4"
                        }
                    },
                    "bandedRowHeaders": true,
                    "valuesOnRow": true,
                    "wordWrap": true,
                    "fontFamily": "Calibri",
                    "fontSize": 10
                }
            ],
            "subTotals": [
                {
                    "rowSubtotals": true,
                    "columnSubtotals": true,
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "applyToHeaders": true,
                    "applyToLabels": true
                }
            ],
            "rowTotal": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "applyToHeaders": true
                }
            ],
            "columnTotal": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "applyToHeaders": true,
                    "fontSize": 10
                }
            ],         
            "totals": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "bold": true,
                    "applyToHeaders": true,
                    "applyToLabels": true,
                    "fontSize": 10
                }
            ]
        }
    }
}

问题根源 #

1. 行小计配置缺失：rowTotal节点未添加applyToLabels=true，导致行小计的标签无法应用指定字体格式
2. 列总计配置缺失：columnTotal节点同样缺少applyToLabels=true，使得列总计标签的字体设置不生效

修正后的主题代码 #

{
    "name": "Test",
    "pivotTable": {
        "*": {
            "stylePreset": [
                {
                    "name": "Default"
                }
            ],
            "grid": [
                {
                    "gridVertical": false,
                    "gridHorizontal": false,
                    "rowPadding": 4,
                    "outlineWeight": 2,
                    "textSize": 10
                }
            ],
            "columnHeaders": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#ffffff"
                        }
                    },
                    "backColor": {
                        "solid": {
                            "color": "#142640"
                        }
                    },
                    "outline": "None",
                    "outlineColor": {
                        "solid": {
                          "color": "#0e1622"
                        }
                    },
                    "outlineWeight": 1,
                    "autoSizeColumnWidth": true,
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "bold": true,
                    "alignment": "Left",
                    "titleAlignment": "Left",
                    "wordWrap": true
                }
            ],
            "rowHeaders": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "outline": "RightOnly",
                    "outlineColor": {
                        "solid": {
                          "color": "#0e1622"
                        }
                    },
                    "outlineWeight": 1,
                    "stepped": true,
                    "steppedLayoutIndentation": 10,
                    "wordWrap": true,
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "alignment": "Left",
                    "showExpandCollapseButtons": true
                }
            ],
            "values": [
                {
                    "fontColorPrimary": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "backColorPrimary": {
                        "solid": {
                            "color": "#ffffff"
                        }
                    },
                    "fontColorSecondary": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "backColorSecondary": {
                        "solid": {
                            "color": "#F4F4F4"
                        }
                    },
                    "bandedRowHeaders": true,
                    "valuesOnRow": true,
                    "wordWrap": true,
                    "fontFamily": "Calibri",
                    "fontSize": 10
                }
            ],
            "subTotals": [
                {
                    "rowSubtotals": true,
                    "columnSubtotals": true,
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "applyToHeaders": true,
                    "applyToLabels": true
                }
            ],
            "rowTotal": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "applyToHeaders": true,
                    "applyToLabels": true
                }
            ],
            "columnTotal": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "fontSize": 10,
                    "applyToHeaders": true,
                    "applyToLabels": true
                }
            ],         
            "totals": [
                {
                    "fontColor": {
                        "solid": {
                            "color": "#0e1622"
                        }
                    },
                    "fontFamily": "Calibri",
                    "bold": true,
                    "applyToHeaders": true,
                    "applyToLabels": true,
                    "fontSize": 10
                }
            ]
        }
    }
}

修改说明 #

• 在rowTotal节点添加"applyToLabels": true，确保行小计标签应用Calibri 10号字体
• 在columnTotal节点添加"applyToLabels": true，解决列总计标签的字体格式问题
• 保持所有小计、总计节点的字体参数一致，避免层级覆盖导致设置失效

内容的提问来源于stack exchange，提问作者Michella