Forum Discussion
Solved
Conditional formatting row by row
I've created the following measure: bank_sales_amount = CALCULATE( sum(sale_order[sales_amount]), dim_activity_area[name] = "banks" ) I've drag this measure to a table visualizat...
There is a similar solution here (I do recommend to read every replies):
Re: Row by row Conditional Formatting on a Matrix - Microsoft Fabric Community
Hi powerbi2srm ,
For this you need to add an additional measure that makes your calculation identify the best month should be similar to this:
Colour coding =
VAR temptable =
CALCULATETABLE (
SUMMARIZE (
sales_order,
geography[countries],
'Calendar'[Month],
'Calendar'[Year],
"_banksalesamount", [bank_sales_amount]
),
ALLSELECTED ( 'Calendar' )
)
RETURN
IF ( [bank_sales_amount] = MAXX ( temptable, [_bank_sales_amount] ), "#000000" )
Replace the #000000 by the colour coding you want then use this measure has your condittional formatting.
This formula may need adjustment based on your model.
That code doesn't run because calendar, sale_order and dim_geography are different tables