Forum Discussion
Conditional formatting of measures
Hi, I have multiple measures in my report and I want to make the font color change based on the value of the measure. Let's say i have two measure; measure A and measure B, which are both pe...
cengizhanarslan
Super User
Super UserBecause all your measures are shown in the same table/matrix, you can use dynamic conditional formatting with SELECTEDMEASURE(). This lets one single rule apply to any measure placed in the visual.
Create one formatting measure like this:
Font Color =
VAR v = SELECTEDMEASURE()
RETURN
IF( v < 0, "#C00000", "#00B050" )
Then, in your table or matrix:
Open Conditional formatting → Font color
Choose Format by: Field value
Select Font Color (the measure above)
Hi Cengi! Thanks. I tried this but this leads to similar issues where all values just return blank/null. See reply Krish above.
Any idea on how to solve this?