Forum Discussion

Garrysfarrell's avatar
Garrysfarrell
Frequent Visitor
5 years ago
Solved

Theme JSON code for Total labels

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"
}

 

 

Need Help
  • rogerlight's avatar
    rogerlight
    4 years ago

    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

5 Replies

    • Garrysfarrell's avatar
      Garrysfarrell
      Frequent Visitor
      5 years ago

      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's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        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!

  • Garrysfarrell's avatar
    Garrysfarrell
    Frequent Visitor
    5 years ago

    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"

     

  • rogerlight's avatar
    rogerlight
    Frequent Visitor
    4 years ago

    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