Conditional Formatting - matrix row

[jcastr02]

Trying to set up a cond formatting to the highest number in each row, to be background color of dark grey.  The values are not coming from any measure.  I am doing % of row total of responses.  See pic below.  

[v-lionel-msft]

Hi @jcastr02 ,

Create a measure like this:

Max_grey = 
VAR x = 
CALCULATE(
    MAX(Sales[Sale 2013]),
    ALLEXCEPT(
        Sales,
        Sales[Brand]
    )
)
RETURN
IF(
    MAX(Sales[Sale 2013]) = x,
    "grey",
    "white"
)

Then, do like this:

(The matrix in the picture is the effect I have achieved, I just repeat the operation again.)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jcastr02]

@v-lionel-msft seems it's only shading the first column.  

Attached is the file - see 30 day feedback tab

https://1drv.ms/u/s!Ava_12t7CNJtkCGALXOtGpymk1pF 

[rajulshah]

Hello @jcastr02,

Can you provide sample data or sample power bi file? Because I am able to achieve it in my file.

[jcastr02]

Hello @rajulshah

 https://1drv.ms/u/s!Ava_12t7CNJtkCGALXOtGpymk1pF  

Please see link.  I appreciate your help!

[jcastr02]

@rajulshah 

See 30 Day Feedback Tab, thanks.

[rajulshah]

@jcastr02, Well, I just disabled and then enabled conditional formatting option for the field and it worked. See below:

Please try once again and let me know if it worked.

[jcastr02]

@rajulshah    I am trying to get only a grey background color  for the highest (or max) number in each ROW.  It seems I may have to do a conditional format based on a measure, but can't figure out the DAX for it.