Forum Discussion
Conditional Formatting on Field Value Switch not working
Hi, I am trying to use a measure to change the font colour and title of a visual card. The switch function has been set up to determin colour based on 2 meassure. I want the colour to be gre...
Hi, MichaelO
I tried to reproduce your problem, but unsuccessfully. 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.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.