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
相关产品推荐
相关产品推荐

