Remove conditional formatting for grand totals in matrix visual

[shruti_jain]

We have a scenario where we are applying conditional formatting to totals in a matrix view which is having a group of 2 categories(Paid and Unpaid) based on Aging buckets. The same formatting is getting applied to Rows Grand Total and Columns Grand Total. We don’t want the formatting on the Grand Totals.

Actual Result:  

Expected Result: There should not be any formatting on the Grand Totals

We tried creating below measure to exclude the formatting on grand total, but it dint work out.

ConditionalFormatMeasure =

IF(
    HASONEVALUE('Table'[Category]) && 
    NOT ISINSCOPE('Table'[Grand Total Column]),
    [Your Original Measure],
    BLANK()
)

[SamInogic]

Hi,

You have to change the apply to options in the conditional formatting,

Navigate to the Conditional Formatting > Choose the formatting > Apply to > Values Only

Please refer to the screenshot given below,

Save the formatting.

Hope this helps.

Thanks!

[shruti_jain]

Hi, 

Thanks for your reply. But i dont want the formatting on the values. I want the formatting only on the subtotals, which will work by selecting the Totals only. At the same time, its applying on Grand totals too. I want to remove conditional formatting on only Grand Totals

[Anonymous]

Hi @shruti_jain 

Thanks for the reply from @SamInogic .

@shruti_jain , from my testing, it seems that the conditional formatting of the grand total cannot be set separately from that of the subtotal. But I think your idea makes sense and you can submit an idea for it at: Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

Hopefully this will be possible in a future release.

Best Regards,
Yulia Xu

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