Color coded based on conditions

MK3010 · October 5, 2020, 9:33am

Hi @amruthdna2018

You can use the below DAX code to create a measure which will be used to conditional formatting . You can change your condition per your requirement.

ColorcodeValue = 
SWITCH( 
    TRUE(),
    SELECTEDVALUE( 'Table'[CurrentQty]) <=SELECTEDVALUE('Table'[Safesideqty]), -1,
    SELECTEDVALUE('Table'[CurrentQty]) >SELECTEDVALUE('Table'[Safesideqty]) && SELECTEDVALUE('Table'[CurrentQty]) < SELECTEDVALUE('Table'[Minlot] ),1
)

Steps to format:-

Select the table and goto Format.
Select “Conditional Formatting”
Select "Status from the drop down( the column on which you want to do formatting)
Turn On the Background Color
Click on “Advanced Controls”

Have the below setup and click ok.

The output.

Hope this helps you.

Thanks
Mukesh