Conditional Formatting for specific column in Matrix Visual

[saudansari]

Hi 

I am using Conditional formatting using the Dax = 
NumericAHT =
AVERAGE(support__cw_ops_manage_case_merge_temp[FormattedAHT])

however, as you can see below in the image the matrix visual has a column  hours type created by DAX = 

Business Hours =

IF(

    AND(

        [Time] >= TIME(8, 0, 0),

        [Time] < TIME(18, 0, 0)

    ),

    "Business Hours (8 AM - 6 PM)",

    "Off-Hours (7 PM - 7 AM)"

)

I want to use the conditional formatting for only the business hours column under Column AHT

@Ahmedx @lbendlin @Ritaf1983 @parry2k @amitchandak @Idrissshatila @Ashish_Mathur  Request you to please help

[Fowmy]

@saudansari 

Create a measure to use for your CF as follows as per this example:

CF = 
IF(
    SELECTEDVALUE( 'Date'[Year] ) = 2018 && SELECTEDVALUE( 'Date'[Month Number] ) = 1 , 
    [Total Quantity]
)

[saudansari]

The column is hours type and where I get two columns one business hours and the other off-hours, however, the value is one AHT, Chat to Close when I use conditional formatting it is applying for AHT in both columns together

[saudansari]

To add the values in the matrix using the DAX - 

AVG AHT = FORMAT(AVERAGE(support__cw_ops_manage_case_merge_temp[FormattedAHT]), "hh:mm:ss")
Basically formatted them in hh:mm:ss 

@Ahmedx @lbendlin @Ritaf1983 @parry2k @amitchandak @Idrissshatila @Ashish_Mathur