Forum Discussion
Solved
Colour Formatting based on a measure
I was just wondering if anyone could provide any advice in regards to Conditional Formatting with a measure as I am almost getting the correct results but I dont know if the decimal is the issue. ...
Hi PaulaL,
This is caused the real data which might be 0.281, it will use real data to compare instead of use transformation data. So if you want to achieve your goal, you could try to use below measure on conditional formatting
Measure = var A=ROUND(MIN('Table'[column A]),2) var B=ROUND(MIN('Table'[column B]),2) return SWITCH(TRUE(),a=b,"#D6D94C",a<b,"#F5BCF7","#8FEBE9")Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi PaulaL,
This is caused the real data which might be 0.281, it will use real data to compare instead of use transformation data. So if you want to achieve your goal, you could try to use below measure on conditional formatting
Measure = var A=ROUND(MIN('Table'[column A]),2) var B=ROUND(MIN('Table'[column B]),2) return SWITCH(TRUE(),a=b,"#D6D94C",a<b,"#F5BCF7","#8FEBE9")
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.