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?