提问人：Michella 提问时间：11/17/2023 更新时间：11/17/2023 访问量：8
Power Bi Json 主题 - 数据透视表行小计格式不起作用
Power Bi Json Theme - Pivot Table Row Subtotal Formatting not working
问：
我正在为我的公司创建一个 json 主题文件，但我被困在矩阵表上。它只是不接受行小计的输入。
代码如下：
{
"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
}
]
}
}
}
当我将其加载到报告中时，有两个没有做我想做的（见附图）：
- 列总计需要为 Calibri 10，应用于标签 true
- 行小计也需要为 Calibri 10，应用于标签 true
答：
0赞
Michella
11/17/2023
#1
好的，在尝试不同的东西后自己解决了。我不得不转到小计部分并分别定义行小计和列小计的字体，如下所示：
"rowSubtotals": true,
"fontFamilyrowSubtotals": "Calibri",
"fontSizerowSubtotals": 10,
"columnSubtotals": true,
"fontFamilycolumnSubtotals": "Calibri",
"fontSizecolumnSubtotals": 10
这是整个解决方案：
{
"name": "MatrixTemplate",
"visualStyles": {
"pivotTable": {
"*": {
"stylePreset":[{
"name":"Default"
}],
"grid": [{
"gridVertical": false,
"gridVerticalColor": { "solid": { "color": "#F4F4F4"}},
"gridVerticalWeight": 2,
"gridHorizontal": false,
"gridHorizontalColor": { "solid": { "color": "#F4F4F4"}},
"gridHorizontalWeight": 2,
"rowPadding": 4,
"outlineColor": { "solid": { "color": "#F4F4F4"}},
"outlineWeight": 2,
"textSize": 10,
"imageHeight": 100
}],
"columnHeaders": [{
"fontColor": { "solid": { "color": "#ffffff"}},
"backColor": { "solid": { "color": "#142640"}},
"autoSizeColumnWidth": true,
"fontFamily": "Calibri",
"fontSize": 10,
"bold": true,
"alignment": "Left",
"titleAlignment": "Left",
"urlIcon": true,
"wordWrap": true
}],
"rowHeaders": [{
"fontColor": { "solid": { "color": "#0e1622"}},
"backColor": { "solid": { "color": "#ffffff"}},
"outline": "Frame",
"outlineColor": { "solid": { "color": "#142640"}},
"outlineWeight": 1,
"stepped": true,
"steppedLayoutIndentation": 12,
"urlIcon": true,
"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,
"outline": "Frame",
"urlIcon": true,
"wordWrap": true,
"fontFamily": "Calibri",
"fontSize": 10
}],
"subTotals": [{
"rowSubtotals": true,
"fontFamilyrowSubtotals": "Calibri",
"fontSizerowSubtotals": 10,
"columnSubtotals": true,
"fontFamilycolumnSubtotals": "Calibri",
"fontSizecolumnSubtotals": 10,
"applyToHeaders": true,
"perRowLevel": true,
"perColumnLevel": true
}]
}
}
}
}
评论