Conditional Formatting on Total & Subtotals AND Centering the data in Total's

[Anonymous]

Hello All,

I am facing 2 issues -

1. I have conditional formatting on G% based on its value but the same is not available in TOTAL, how to apply the same in TOTAL as well?

2. I have made the table center aligned but TOTAL's are still right-aligned, is there any way to make alignment center as well?

Thanks,

[v-lili6-msft · Accepted solution]

hi @Anonymous 

1. Unfortunately, the conditional formatting does not apply for the subtotal and total in the current release desktop. Here is the idea, Please refer to it:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in

2. Look at the picture, please enable “Apply to subtotal” and “Apply to total” for the fields in Format->Field formatting, then it will work well.

Regards,

Lin