Forum Discussion
Calculation Group - conditional formatting
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:
Any ideas are highly appreciated! 🙂
Thanks!
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 ResultThe 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:
3 Replies
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 ResultThe 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:
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())
