Forum Discussion
Conditional formatting row by row
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
How are the tables related?
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.This case that I'm looking for (there a are a pbix in replies). However, when I use that code and I filter by more than one year (in a slicer) I don't have the result that I expect: the code doesn't work properly.