Color coding same value with different quarters

[Tushar_IG]

Hi 

I am trying to create 2 cards with same value and linked them with 2 slicers - (quarter and year) and used edit interaction so, I can compare 2 different qurter and then color code both card visuals on the baises of greater than-red, equals to=yellow and less than-green by dax. But even though cards shows different value color code is appearing for equals only.

Dax: 

1st # of Trials = CALCULATE([# of Trials],

FILTER(Date2,

Date2[Year] = SELECTEDVALUE(Date2[Year]) &&

Date2[Quarter] = SELECTEDVALUE(Date2[Quarter])))

2nd # of Trials = CALCULATE([# of Trials],

FILTER(Date2,

Date2[Year] = SELECTEDVALUE(Date2[Year]) &&

Date2[Quarter] = SELECTEDVALUE(Date2[Quarter])))

1st color = IF([1st # of Trials] > [2nd # of Trials], "Red",

IF([1st # of Trials] = [2nd # of Trials], "Yellow",

IF([1st # of Trials] < [2nd # of Trials], "Green")))

2nd color = IF([2nd # of Trials] > [1st # of Trials], "Red",

IF([2nd # of Trials] = [1st # of Trials], "Yellow",

IF([2nd # of Trials] < [1st # of Trials], "Green")))

Please assist it's urgent.

[v-zhangti · Accepted solution]

Hi, @Tushar_IG 

You can try the following methods. In order to make the two slicers work separately, a new date table needs to be created.

Table:

Date = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

Measure:

1st # of Trials = CALCULATE(SUM('Table'[# of Trials]))

2nd # of Trials =
CALCULATE (
    SUM ( 'Table'[# of Trials] ),
    FILTER (
        ALL ( 'Table' ),
        [Year] = SELECTEDVALUE ( 'Date'[Year] )
            && [Quarter] = SELECTEDVALUE ( 'Date'[Quarter] )
    )
)

Measure about the color does not need to be changed. Measure needs to be added to the background color of the card.

1st color = IF([1st # of Trials] > [2nd # of Trials], "Red",
IF([1st # of Trials] = [2nd # of Trials], "Yellow",
IF([1st # of Trials] < [2nd # of Trials], "Green")))

2nd color = IF([2nd # of Trials] > [1st # of Trials], "Red",
IF([2nd # of Trials] = [1st # of Trials], "Yellow",
IF([2nd # of Trials] < [1st # of Trials], "Green")))

Set the background color for the two cards separately, and you can filter the slicer to compare the quarterly values.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[VijayP]

@Tushar_IG 

Try this formula and use this same conditional formatting for both cards

and see the result

1st color = IF([1st # of Trials] - [2nd # of Trials]<0 "Red",

IF([1st # of Trials] - [2nd # of Trials]=0, "Yellow",

IF([1st # of Trials] - [2nd # of Trials]>0, "Green")))

[Tushar_IG]

Hi @VijayP,

I tried that but didn't work still color coding is yelloow.