Conditional formatting row by row

[powerbi2srm]

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 visualization. This visualization have geography (countries) as columns and months as rows.

I want to create a conditional color format to returns what are the best months for each row (geography).  For example, with this table I want to know through the color if april was a good month in Spain or if september was a good month in France

thank you!!

[MFelix]

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.

[powerbi2srm]

That code doesn't run because calendar, sale_order and dim_geography are different tables

[MFelix]

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.

[powerbi2srm]

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.

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-by-row-Conditional-Formatting-on...

[powerbi2srm · Accepted solution]

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