PROBLEM: I am trying to create a custom PBI theme with a custom matrix. I am having trouble getting the grand total to appear at the bottom of the matrix. It only appear at the very top.
DETAILS: I noticed when I completely delete the code for "rowHeaders": , the grand total correctly appears at the bottom. However, when I put ANYTHING in the "rowHeaders": section (such as font size, and stepped = false etc.) the grand total moves to the top of the matrix. I would rather not completely delete my code within "rowHeaders": since the code within "rowHeaders": is important to the theme.
MY CODE:
{
"visualStyles": {
"pivotTable": {
"*": {
"grid": [
{
"gridVertical": false,
"gridVerticalColor": { "solid": { "color": "E7E7E7" } },
"gridVerticalWeight": 1,
"gridHorizontal": true,
"gridHorizontalColor": { "solid": { "color": "E7E7E7" } },
"gridHorizontalWeight": 1,
"rowPadding": 2,
"outlineColor": { "solid": { "color": "FBFBFA" } },
"outlineWeight": 1,
"textSize": 9,
"imageHeight": 75
}
],
"columnHeaders": [
{
"fontColor": { "solid": { "color": "#3E658B" } },
"backColor": { "solid": { "color": "#D9DEE3" } },
"outline": "Bottom only",
"autoSizeColumnWidth": true,
"fontFamily": "Arial",
"fontSize": 14,
"alignment": "Center",
"wordWrap": true
}
],
"rowHeaders": [
{
"fontColor": { "solid": { "color": "#00B8DD" } },
"backColor": { "solid": { "color": "#00AA22" } },
"outline": "Right only",
"stepped": false,
"steppedLayoutIndentation": 12,
"urlIcon": true,
"wordWrap": true,
"fontFamily": "Arial",
"fontSize": 12,
"alignment": "Left"
}
],
"values": [
{
"fontColorPrimary": { "solid": { "color": "#000000" } },
"backColorPrimary": { "solid": { "color": "#FFFFFF" } },
"frontColorSecondary": { "solid": { "color": "#000000" } },
"backColorSecondary": { "solid": { "color": "#F0EFEF" } },
"outline": "None",
"urlIcon": false,
"wordWrap": true,
"fontFamily": "Arial",
"fontSize": 12
}
],
"subTotals": [
{
"rowSubtotals": true,
"columnSubtotals": true,
"fontColor": { "solid": { "color": "#000000" } },
"fontFamily": "Arial",
"fontSize": 12,
"applyToHeaders": false,
"rowSubtotalsPosition": "Bottom",
"perRowLevel": true,
"perColumnLevel": true
}
],
"total": [
{
"fontColor": { "solid": { "color": "#333333" } },
"backColor": { "solid": { "color": "#FFFFFF" } },
"fontFamily": "Arial",
"applyToHeaders": true,
"fontSize": 12
}
]
}
}
}
}
Thanks in advance!
