Forum Discussion

claxxx's avatar
claxxx
Frequent Visitor
2 years ago

Conditionnal formating with 2 Calculation group

Hello All, I'm trying to apply a conditionnal formating to a table where I have 2 Calculation Group: - One with my measures  - One with Time variation (actual, p-1, and var %)   I want to apply ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi claxxx ,

If I understand correctly, the issue is that you want to apply a conditional formatting to make the positive is red and the negative is green. Please try the following methods and check if they can solve your problem:

1.Create a measure. Enter the following DAX formula.

 

Measure = 
var _persales = SELECTEDVALUE('MESURE GROUP'[Mesure])
var _salesvar = SELECTEDVALUE('TIME VAR'[Variation])
RETURN
    IF (
        _salesvar IN {"ACTUAL", "P-1"},
        BLANK(),
        IF (
            _persales = "Cost per Sales" && _salesvar = "VAR",
            BLANK(),
            1
        )
    )

 

2.Select the INIT KPI values and choose the conditional formatting.

3.Select the measure and set the Rules.

 

 

4.The result is shown below.

 

Best Regards,

Wisdom Wu

 

 

 

claxxx's avatar
claxxx
Frequent Visitor
2 years ago

Thank you for your answer. 

My point was principally to apply a conditionnal formating only to the "VAR %" column. 

So for all measures the column "Actual" and "P-1" should maintain without any color, and VAR % have to be the only column with a conditionnal color. 

In your result I see that the 3 column "Actual", "P-1", and "VAR %" have the conditional format but I just want VAR % to have it. Do you have a solution to do that?