Matrix table with dynamic gradient background color when there's hierarchy level

Hi LucasBW 

That is a known limitation. Gradient conditional formatting on totals require values to be hardcoded. This has already been posted as an idea https://community.fabric.microsoft.com/t5/Fabric-Ideas/Conditional-Formatting-should-apply-format-in-SubTotals-and/idi-p/4469846

A workaround is to use a measure that returns a color dynamically. This is a bit advance but this is a good read

 https://www.esbrina-ba.com/conditional-formatting-with-a-dynamic-divergent-color-gradient-for-values-and-totals/