Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Sub Total formatting in cross tabs not retained on Report Server

Hi,  some sub total formating that i apply in Desktop (May 2022 RS version) on cross tab tables is not being retained after loading to the server (May 2022 Report Server).  In particular if i set the table 'Style' to 'None' and then apply sub total formatting it's not being retained.  (I am setting the initial format style to 'None' as i want to start with a transparent table). 


Example crosstab:


How it looks on Desktop:



How it looks after loading to Report Server:




You can see that any formatting i apply to the Sub total columns is lost.  i.e. any background colour reverts to nothing and any text colour reverts to black.




Community Support
Community Support

Hi @wellf100 ,


Just a quick check with you if your report has a custom theme applied in Desktop for Power BI Report Server? Does this issue occur after the custom theme is modified?


Also,you may check if this similar thread helps

Solved: Loosing Formatting after Publishing report to the ... - Microsoft Power BI Community


Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.


Hi, i have tried creating a new blank report with no theme at all and the same happens.  


I also cleared my browser cache and no difference.

Helper I
Helper I

in fact setting the table 'style' makes no difference.  regardless of the style any formatting of sub totals is not retained.

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.