Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@Anonymous,
I am unable to reproduce the above issue using your JSON code. Could you please update to latest version of Power BI Desktop(2.65.5313.701 ) and check the issue?
Meanwhile, you can make a test in my PBIX file. If the issue still persists, please share your PBIX file through Private Message.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |