Hi all, I'm trying to generate a draft email with a table containing data from my Power BI.
I have a column called "ISR vs LPA", which I would like to apply conditional formatting for. If the value is between 0.8 and 1.2, the cell should be highlighted green. Otherwise, it should be highlighted red.
I tried something like the below but it does not work. Appreciate all help thank you!
Hi @Anonymous
Pls try wrapping left side operand that comes from power BI inside float() formula to make it compatible for the comparison. You need to type cast both left side operand coming from Power BI.
Here is an example of converting string to float used for comparison:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks