Forum Discussion
Matrix Conditionally Formatted Above or Below Total
Trying to format so that a given row is higher or lower than the total of the column. Example --> Product Profit Margin Candy Bars 60% Potato Chips 50% Ice Cream 35% Tota...
nj-matt , You can use rule base of color measure
Assuming Profit Margin is a measure
color = Switch(true(),
[Profit Margin] >.55 , "green",
"red"
)
use that in conditional formatting with the field value option
Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
Thanks for the quick reply -
Should have clarified - I need this to be dynamic. So for example 55% is the total if they have selected year 2021 but if they choose year 2020 it will be a different total and a different value for each of the products.
And yes, profit margin is a measure.
