You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Power BI JSON主题数据透视表总计样式不生效问题求助

问题:Power BI数据透视表总计样式JSON主题配置失效
  • 尝试通过JSON主题设置数据透视表总计(grand totals)的背景色与字体色,但配置完全不生效
  • 出现了JSON中未定义的黑色背景,排查确认并非全局设置问题,移除pivotTable配置段后黑色背景消失
  • 总计的字体样式继承自subTotals配置,而非单独设置的totals段,尝试过'total'、'grandTotal'等多种字段名称均无效果

期望总计能够正确应用totals段的颜色设置,当前数据透视表的JSON配置如下:

"pivotTable": {
    "*": {
        "stylePreset": [{
            "name": "Condensed"
        }],
        "grid": [{
            "gridVertical": true,
            "gridVerticalColor": { "solid": { "color": "#E6E6E6"}},
            "gridVerticalWeight": 1,
            "gridHorizontal": true,
            "gridHorizontalColor": { "solid": { "color": "#E6E6E6"}},
            "gridHorizontalWeight": 1,
            "rowPadding": 1,
            "outlineColor": { "solid": { "color": "#E6E6E6"}},
            "outlineWeight": 1,
            "textSize": 10,
            "imageHeight": 100
        }],
        "columnHeaders": [{
            "fontColor": { "solid": { "color": "#454545"}},
            "backColor": { "solid": { "color": "#F6F8FC"}},
            "outline": "Frame",
            "autoSizeColumnWidth": true,
            "fontFamily": "Arial",
            "fontSize": 10,
            "alignment": "Left",
            "titleAlignment": "Right",
            "urlIcon": true,
            "wordWrap": true
        }],
        "rowHeaders": [{
            "fontColor": { "solid": { "color": "#454545"}},
            "backColor": { "solid": { "color": "#FFFFFF"}},
            "outline": "Frame",
            "stepped": true,
            "steppedLayoutIndentation": 12,                 
            "urlIcon": true,
            "wordWrap": true,
            "fontFamily": "Arial",
            "fontSize": 10,
            "alignment": "Left", 
            "showExpandCollapseButtons": true
        }],
        "values": [{
            "fontColorPrimary": { "solid": { "color": "#454545"}},
            "backColorPrimary": { "solid": { "color": "#FFFFFF"}},
            "fontColorSecondary": { "solid": { "color": "#454545"}},
            "backColorSecondary": { "solid": { "color": "#FFFFFF"}},
            "bandedRowHeaders": true,
            "valuesOnRow": false,
            "outline": "Frame",
            "urlIcon": true,
            "wordWrap": true,
            "fontFamily": "Arial",
            "fontSize": 9
        }],
        "subTotals": [{
            "rowSubtotals": true,
            "columnSubtotals": true,
            "fontColor": { "solid": { "color": "#454545"}},
            "fontFamily": "Arial",
            "backColor": { "solid": { "color": "#FFFFFF"}},
            "fontSize": 10,
            "applyToHeaders": true,
            "rowSubtotalsPosition": "Bottom",
            "perRowLevel": true,
            "perColumnLevel": true                  
        }],             
        "totals": [{
            "fontColor": { "solid": { "color": "#454545"}},
            "fontFamily": "Arial",
            "backColor": { "solid": { "color": "#FFFFFF"}},
            "applyToHeaders": true,
            "fontSize": 10
        }]
    }
}

数据透视表效果截图

内容的提问来源于stack exchange,提问作者data_sc

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.08.12 05:55:30