Templates, formatting % & numbers, Inscope levels

[deltaselect]

Hi @BCS

Would the methodology explained by Mudassir Ali brings you any further ? Not to forget the others in this post, Heather, Brian and bradsmith

Conditional format negative percentages

@suzanne First you can create the measure to assign values as follows: When < -50% the value is 1, When <= -35%, the value is 2, When <=0%, the value is 3. CF = IF ( [MOM %] < -0.50, 1, IF ( [MOM %] <= -0.35, 2, IF ( [MOM %] <= 0, 3 ) ) ) Select the column where you want the conditional formatting. Here I have applied it on the MOM%. Then turn on the toggle of Font Colors or Background Color whatever you want to conditionally format and then click on Advanced Controls [4] At final stag…