Theme JSON code for Total labels

[Garrysfarrell]

I am using this code to control the data labels for the Stacked Bar Chart. However, I want to add the "Total labels" to the theme JSON file but I cannot find any documentation for the Total labels. I checked these pages but they may be out of date. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes

https://powerbi.tips/tools/report-theme-generator-v3/

https://github.com/deldersveld/PowerBI-ThemeTemplates

"barChart": {

...

,
"labels": [
{
"show": true,
"color": { "solid": { "color": "#FFFFFF" } },
"fontSize": 9,
"fontFamily": "Segoe UI"
}

[rogerlight · Accepted solution]

Hi @Garrysfarrell ,

Here's what you need to add to your barChart theme section:

"totals": [
{
"show": true,
"color": { "solid": { "color": "#FFFFFF" } },
"fontSize": 9,
"fontFamily": "Segoe UI"
}
],

You can sometimes discover the correct terminology by looking in the Layout file inside the unzipped PBIX file.

Hope that helps!

Regards,
Roger

[Garrysfarrell]

Didn't seem to work. I tried all variations of what I thought may be errors.

"show Total" --> "showTotal"

"TotalLable" --> "TotalLabel"

"TotalLable" --> "totalLabel"

"TotalLable" --> "totalLable"

[v-kelly-msft]

Hi  @Garrysfarrell ,

Check the newly updated one:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Garrysfarrell]

I used this code. Not sure if this is correct but it didn't work. Pic below highlighting the "Total Labels" that I'm trying to change with the theme.

"total": [
{
"show": true,
"color": { "solid": { "color": "#448822" } },
"fontSize": 9,
"fontFamily": "Arial"
}
]

[v-kelly-msft]

Hi @Garrysfarrell，

Try below json code:

"total": [
{
"show Total": true,
"TotalLable":"Total",
"color": { "solid": { "color": "#448822" } },
"fontSize": 9,
"fontFamily": "Arial"
}
]

Or check below blog for help:

https://zebrabi.com/power-bi-themes/

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!