JSON theme help

[Anonymous]

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:

Spoiler

    "tableEx": {
      "*": {
        "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
          }
        ]
      }
    },

[V-lianl-msft · Accepted solution]

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.

[Anonymous]

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.

[V-lianl-msft]

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.

[Anonymous]

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.

[parry2k]

@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!

[Anonymous]

Hello @parry2k ,

This is not about the subtotals, but rather the grand total. There is no option to show the grand total on top or bottom.

[parry2k]

@Anonymous I don't think there was an option to move grand total to the top. 

[Anonymous]

Hi @parry2k ,

It is happening anyway. I've made a few screenshots proving it's not the subtotal row, but the grand total that is showing on top.

The problem occurs after applying my custom theme. It shows at the bottom when the default Power BI themes are applied.