Forum Discussion
Help! Heat map using Matrix visual
I have a Matrix visual that shows percentage % in Qtuarterly and monthly in Excel as bolow and I have applied gradient colounr in Excel like below. this pictures indicates that after comple...
Hi Anonymous ,
Try changing the IF statement to a SWITCH statement, as the IF statement may have dependencies that cause conditions to not match exactly.
SWITCH function (DAX) - DAX | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.