Conditional Formatting a Matrix with multiple columns

[melimob1]

Hi, 

I have a matrix table in pbi and I want comparing for each company (LOB) which product is the max %.

Something like this:

I have a summary table where there is a column to denote by LOB and product, which is the dominant.

I'm stuck on creating the conditional format to apply as a field rule however.

would be grateful for any advice?

many thanks

[Bibiano_Geraldo · Accepted solution]

Hi @melimob1 ,

If i understood well, you need to create a measure to rank the countries, something like this:

Rank = 
RANKX(
    ALL(financials[Country]),
    [Sales Mix %],
    ,DESC
)

Now you can add a background color using conditional format to your % column as shown bellow:

Use these rules and click OK:

Now your result should look like this:

[melimob1]

that dear friend is a beautiful thing!!! 
worked like a charm first time (I just change the field I wanted to rank against). 

I can't thank you enough, finally... something was simple 😉 

ps.  I will post something else if I need to but in another matrix, I also need to colour code one column if the value on that row doesn't match with another colum (same row).. shall I do a new post for tracking? or is this something easy?

[Bibiano_Geraldo]

Happy that it worked,
If your create a post, just @me to to let me know and dont forget to show your expected results in the post.

Thank you.

[melimob1]

hey, I got fancy also as used your rank measure just to show an icon for the top as well as colour! thank you again!

[Bibiano_Geraldo]

😀😀😀The sky is limit.