Forum Discussion
JSON Theme Subtotals
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
}]
}
}
14 Replies
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.
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.
Hi cassandra_c
In my example the bottom row is actually the sub-total
To confirm:
The values are unbolded.
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.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 youThis 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.
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
Hi @sasdfasdfsad ,
Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.
Regards
