Visual Calculations

Hi Git ,

Based on your problems, here are my answers.

You can apply conditional formatting rules to totals and subtotals in both table and matrix visuals. You can also read this document for the further study: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

However, you must manually set the thresholds and ranges for conditional formatting rules under Minimum and Maximum instead of using the lowest and highest values based on the measure you provide.

Use a measure to dynamically set the limits for conditional formatting isn’t directly supported now.

To achieve conditional formatting specifically at the grand total level, consider collapsing the entire level in the Matrix Row Hierarchy. Conditional formatting won’t be visible on the parent level of the hierarchy if any child level is expanded. Close all child levels to see the formatting applied to the grand total.

Best Regards

Yilong Zhou

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