topic Re: Calculation Group - conditional formatting in DAX Commands and Tips

Calculation Group - conditional formatting

cn4422 — Tue, 11 Feb 2025 15:10:38 GMT

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!

Re: Calculation Group - conditional formatting

DataInsights — Tue, 11 Feb 2025 22:41:42 GMT

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

Re: Calculation Group - conditional formatting

cn4422 — Wed, 12 Feb 2025 09:23:02 GMT

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()

)

Re: Calculation Group - conditional formatting

DataInsights — Wed, 12 Feb 2025 18:21:38 GMT

cn4422,

Glad to hear it worked!