How to fix subtotal formatting change from 2018 to 2022

[Anonymous]

When I open this report on Power BI Report Server Aug 2018 (originally created back then), in the Power BI Desktop for Report Server (Sept 2022) the subtotal line formatting is not the same.

I can't figure out how to format it the same as it was. When I go to the matrix's Row subtotals\apply settings to\per row level (On)\select a single series... the Rows fomatting section only has options for setting an alternate totals label. The Values section is disabled.

Any ideas?

[v-cgao-msft]

Hi @Anonymous ,

Please try:

Row subtotals --> Series all and Bold off.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

Hi Gao,  Thanks for the suggestion but what you proposed is how to disable all bolding for all levels. That's not the issue.

The issue is that I would like to turn off bolding at levels 1, 2 & 3 but leave it on for level 4 ("Total") as shows in the 2018 version. This also goes for the background coloring.

When I go to Row Subtotals --> Series, only the "All" option will allow me into the "Values" options. Selecting a specific series disables the "Values" section so I cannot set formatting per series.

FYI, my data source is an Analysis Services Multidimensional cube.