Calculation Group - conditional formatting

[cn4422]

Hi,

I have a matrix table with one value and a calculation group for different time periods + calculations.

What I want is to put conditional formatting on the marked columns in red with + and - signs (see screenshot)

However, I cannot "select" (or don't know how to) those columns because they belong to a calculation group.

I tried to create a color-measure and then select with conditonal formatting (field) this measure, but it didn't work either:

measure_color=

VAR ChangeValue = SELECTEDMEASURE()

RETURN

    SWITCH(

        TRUE(),

        ChangeValue > 0, "#008000", 

        ChangeValue < 0, "#FF0000"

    )

Any ideas are highly appreciated! 🙂

Thanks!

[DataInsights · Accepted solution]

@cn4422,

Try rewriting your measure like this:

measure_color =
VAR ChangeValue = [Count Forms Category]
VAR Result =
    IF (
        SELECTEDVALUE ( 'Calc Group'[name] ) IN { "MyCalcItem1", "MyCalcItem2" },
        SWITCH ( TRUE, ChangeValue > 0, "#008000", ChangeValue < 0, "#FF0000" )
    )
RETURN
    Result

The concept is to wrap the logic in an IF statement that determines if a matrix column is one of the calculation items that needs formatting. The limitation of this approach is that you have to specify the measure name. SELECTEDMEASURE is a calculation item placeholder so it won't work in a measure. Here's a helpful video:

https://www.youtube.com/watch?v=MbxJ1oHHyTg 

[cn4422]

@DataInsights  Thank you very much - also for the Video, awesome stuff! ^^

I put in the following measure and it worked fine:

One Measure Cond Format =

IF(

    SELECTEDVALUE('CalcGroup'[Name]) IN {"Δ LY", "Δ LY in %"},

    [Count Forms Category],

    BLANK()

)

[DataInsights]

@cn4422,

Glad to hear it worked!