JSON Theme Subtotals

[cassandra_c]

I want the subtotals for rows and columns to not be bold. Has anyone successfully turned it off?

Under the Subtotals section, the fontColour, backColour work, but the bold property type doesn't.

I have tried the below bold options (obviously not at the same time), nested under Subtotals, or Rowsubtotals, with different capitalisation iterations. 

Is it possible to control and unbold the subtotal, and leave the grand total as bold?

All other properties within subTotals work: (rowSubtotals, perRowlevel, fontSize, fontColor, backColor)

"pivotTable":
   {
   "*":
      {
      "*":
         [{
            "fontFamily":"wf_standard-font_light",
            "fontSize":9,
            "show": false
         }],

	"subTotals": 
         [{
            "bold":false,
            "boldrowSubtotals":false,
            "rowSubtotalsbold":false,
            "fontWeight":"normal"
         }],

        "rowSubtotals": 
         [{
            "bold":false
         }]
    }
}

[v-nmadadi-msft]

Hi @cassandra_c 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[cassandra_c]

This has not been resolved. Can you confirm if within the ReportTheme Schema that you can change the text format properties (unbold, italics and underline) in the subtotals.

[v-nmadadi-msft]

Hi @cassandra_c ,
Could you check whether applyToHeaders is set to true? If it isn’t enabled, the font settings may not be applied to the headers and subtotal rows.

Regards

[cassandra_c]

apply to headers is irrelevant to the solution. Setting it to true or false does not impact the subtotal rows and columns.

Within Power BI Settings we can manually select and unselect the bold, italic, and underline. This should be possible to be preset within the json theme.

[v-nmadadi-msft]

Hi @cassandra_c ,

On further research this isn’t supported directly in the ReportTheme schema. You cannot control text formatting like bold, italic, or underline specifically for subtotals, which is why those properties don’t have any effect.

The closest workaround is to adjust the font family so the bold styling appears lighter,

Other than adjusting the font styling this way, there isn’t currently a method to explicitly unbold subtotals while keeping the grand total bold through the theme schema.

The allowed parameters to be adjusted using custom themes are found in View -> customize themes

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[cassandra_c]

This is not a solution

[v-nmadadi-msft]

Hi @cassandra_c ,

As this capability is not currently supported in the platform, If the feature is important for your functionality. Please consider sharing your suggestion in the Power BI Ideas forum

Fabric Ideas - Microsoft Fabric Community

where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.

Thank you

[v-nmadadi-msft]

Hi @cassandra_c 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[hnguy71]

Hi @cassandra_c 

Did you mean the values to not be bolded? Try changing the font family and bold control. The following worked for me:

        "subTotals": [
          {
            "bold": false,
            "fontFamily": "Segoe UI Light"
          }
        ],
        "rowSubtotals": [
          {
            "bold": false,
            "fontFamily": "Segoe UI Light"
          }
        ],
        "columnSubtotals": [
          {
            "bold": false,
            "fontFamily": "Segoe UI Light"
          }
        ],
        "rowTotal": [
          {
            "bold": false,
            "fontFamily": "Segoe UI Light"
          }
        ],
        "columnTotal": [
          {
            "bold": false,
            "fontFamily": "Segoe UI Light"
          }
        ]

 
Which gave me this result:

I think there's an inherit 'bolding' that Power BI does. As you can see I used Segoe Light but it still seems it added an extra 100 bold or something.

[cassandra_c]

The values are already unbolded.

It is the subtotal values that need to be unbolded as well.

In your example you aren't showing subtotals, only values and grand total which does not solve my problem.

[hnguy71]

Hi @cassandra_c 

In my example the bottom row is actually the sub-total

To confirm:

The values are unbolded.

[cassandra_c]

The values in your subtotal are still bold. And the font I need to apply is strictly the DIN Light so your workaround is not a viable solution.

[hnguy71]

Hi @cassandra_c 

Yes as I mentioned in my first post that there is an inherited bolding that happens at the total and sub-total line. As a workaround, in order to achieve close to an unbolded value, you should use the light font. In my case, I used 'Segoe UI Light'.