Conditional Formatting on Field Value Switch not working

Question

Hi,&nbsp;I am trying to use a measure to change the font colour and title of a visual card.&nbsp;The switch function has been set up to determin colour based on 2 meassure.I want the colour to be green if current week is larger than previous week.I want the colour to be red if current week is smaller than previous week.Font Colour = SWITCH(&nbsp; &nbsp; TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; [Current Week] &gt; [Previous Week], "green",&nbsp; &nbsp; &nbsp; &nbsp; [Current Week] &lt; [Previous Week], "red", "black"&nbsp;)This meassure works correctly as a card shows the return is red. However, for some reason the conditional formatting is using the green format.The card title confirms this as the title conditional formatting says green. Even though the field is using thE same meassure - "Font Colour."&nbsp;&nbsp;I have tried rearranging the order of my formula to show red first and this hasnt made a difference.I have used if statements as well and no difference. The font colour result shows red in the 3rd card, however the conditional format says green.&nbsp;Any help on why the conditional formatting is not recognising the correct value will be greatly appreciated.Best,Michael

v-zhangti · Answer

Hi,&nbsp;MichaelO&nbsp;
&nbsp;
I tried to reproduce your problem, but unsuccessfully.&nbsp;You can refer to my measure calculation.
Sample data:

Current Week = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Week]=WEEKNUM(TODAY(),2)))Previous Week = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),[Week]=WEEKNUM(TODAY(),2)-1))

You can expand the value of [Current Week] in the table to see if there is a problem with the calculation.
&nbsp;
Best Regards,
Community Support Team _Charlotte
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.