Forum Discussion
JSON theme help
Hi all,
I've created a custom theme using JSON, but now my grand totals row in my table and matrix visuals is showing on top. I cannot find info on how to get this to the bottom anywhere.
Please help, thanks!
My JSON in spoiler:
"*": {
"grid": [
{
"gridVertical": false,
"gridVerticalColor": {
"solid": {
"color": "#FFB8DD"
}
},
"gridVerticalWeight": 1,
"gridHorizontal": true,
"gridHorizontalColor": {
"solid": {
"color": "#E6E6E6"
}
},
"gridHorizontalWeight": 1,
"rowPadding": 0,
"outlineColor": {
"solid": {
"color": "#A31017"
}
},
"outlineWeight": 1,
"textSize": 9,
"imageHeight": 75
}
],
"columnHeaders": [
{
"fontColor": {
"solid": {
"color": "#25272f"
}
},
"backColor": {
"solid": {
"color": "#ffffff"
}
},
"outline": "Bottom only",
"autoSizeColumnWidth": true,
"fontFamily": "Segoe UI",
"fontSize": 9,
"alignment": "Left",
"wordWrap": true
}
],
"values": [
{
"fontColorPrimary": {
"solid": {
"color": "#25272f"
}
},
"backColorPrimary": {
"solid": {
"color": "#ffffff"
}
},
"fontColorSecondary": {
"solid": {
"color": "#25272f"
}
},
"backColorSecondary": {
"solid": {
"color": "#efefef"
}
},
"outline": "None",
"urlIcon": true,
"wordWrap": true,
"fontFamily": "Segoe UI",
"fontSize": 9
}
]
}
},
"pivotTable": {
"*": {
"stylePreset": [
{
"name": "None"
}
],
"grid": [
{
"gridVertical": false,
"gridVerticalColor": {
"solid": {
"color": "#e6e6e6"
}
},
"gridVerticalWeight": 2,
"gridHorizontal": true,
"gridHorizontalColor": {
"solid": {
"color": "#E6E6E6"
}
},
"gridHorizontalWeight": 1,
"rowPadding": 0,
"outlineColor": {
"solid": {
"color": "#A31017"
}
},
"outlineWeight": 1,
"textSize": 9,
"imageHeight": 75
}
],
"columnHeaders": [
{
"fontColor": {
"solid": {
"color": "#25272f"
}
},
"backColor": {
"solid": {
"color": "#ffffff"
}
},
"outline": "Bottom only",
"autoSizeColumnWidth": true,
"fontFamily": "Segoe UI",
"fontSize": 9,
"alignment": "Left",
"urlIcon": true,
"wordWrap": true
}
],
"rowHeaders": [
{
"fontColor": {
"solid": {
"color": "#25272f"
}
},
"backColor": {
"solid": {
"color": "#ffffff"
}
},
"outline": "None",
"stepped": false,
"steppedLayoutIndentation": 10,
"urlIcon": true,
"wordWrap": true,
"fontFamily": "Segoe UI",
"fontSize": 9,
"alignment": "Left",
"showExpandCollapseButtons": true
}
],
"values": [
{
"fontColorPrimary": {
"solid": {
"color": "#25272f"
}
},
"backColorPrimary": {
"solid": {
"color": "#ffffff"
}
},
"fontColorSecondary": {
"solid": {
"color": "#25272f"
}
},
"backColorSecondary": {
"solid": {
"color": "#efefef"
}
},
"bandedRowHeaders": true,
"valuesOnRow": true,
"outline": "None",
"urlIcon": true,
"wordWrap": true,
"fontFamily": "Segoe UI",
"fontSize": 9
}
],
"subTotals": [
{
"rowSubtotals": true,
"columnSubtotals": true,
"fontColor": {
"solid": {
"color": "#000000"
}
},
"fontFamily": "Segoe UI",
"fontSize": 9,
"applyToHeaders": true,
"perRowLevel": true,
"perColumnLevel": true
}
],
"total": [
{
"fontColor": {
"solid": {
"color": "#000000"
}
},
"fontFamily": "Segoe UI",
"applyToHeaders": true,
"fontSize": 9
}
]
}
},
Hi Anonymous ,
Sorry, I'm not skilled in JSON.
You could try to set "stepped" to true.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Anonymous go to format pane and change it to bottom.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Hi Anonymous ,
See if the alternative in this thread can help you:https://community.powerbi.com/t5/Desktop/show-grand-totals-top-bottom-of-matrix/td-p/370909
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi V-lianl-msft ,
That alternative could work, but that does not provide an answer to my question. Why is it that the total shows on the bottom on all themes, but when I apply my own custom theme it shows on top? What causes this to happen and can I solve it through JSON?
It would be unacceptable to always make a dummy total for all matrices and tables that we want to show. There has to be something in the JSON that can solve this.
Thank you.
Hi Anonymous ,
Sorry, I'm not skilled in JSON.
You could try to set "stepped" to true.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi V-lianl-msft ,
When I enable stepped layout, the total row moves to the bottom! Thanks so much, I think this works for my situation.
