topic Re: Conditional formatting in DAX Commands and Tips

Conditional formatting

Jedahn — Tue, 28 Mar 2023 06:21:45 GMT

Hello Everyone,

I applied conditional formatting in score column that if the score of employee is >= 5 it will be colored as green and < 5 will be red. But for employee number 4&5, they only need >= 4 score to achieve the green color. What should be my next step to accomplish this kind of formatting? Thank you very much!!

Applied conditional formatting

Employee_Name	Score
Employee 1	5
Employee 2	4.9
Employee 3	6
Employee 4	4.2
Employee 5	4

Expected result

Employee_Name	Score
Employee 1	5
Employee 2	4.9
Employee 3	6
Employee 4	4.2
Employee 5	4

Re: Conditional formatting

ValtteriN — Tue, 28 Mar 2023 06:52:07 GMT

Hi,

Here is how to do this:

Formatting measure =

IF(MAX('Table (27)'[Score])>=5,"Green","Red")

Place this measure as the conditional format:

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Conditional formatting

Jedahn — Tue, 28 Mar 2023 23:31:35 GMT

Hello. my expected result should be employee 4 and 5 will be marked as green if their score is just >= 4. like in the second table i provided

Employee_Name	Score
Employee 1	5
Employee 2	4.9
Employee 3	6
Employee 4	4.2
Employee 5	4