Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts (note i am using a live connection in power bi and conditonal formating option is out)
How would you amend the current measure using HEX Code or an alternative method to show negative number as red and postive as standard colour.
Measure:
$NSvPY4% (NOE @ AOP Rate) = FORMAT([Net Sales @ AOP Rate BM - NOE]-[Budget Sales BM Reported AOP],"#,##0.0);(#,##0.0)")
Solved! Go to Solution.
Hi Route11,
So your requirement is to achieve different color based on condition, right? Please refer to link below:
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting.
Regards,
Jimmy Tao
Hi Route11,
So your requirement is to achieve different color based on condition, right? Please refer to link below:
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting.
Regards,
Jimmy Tao
Hi Jimmy
becasue this is a "(note i am using a live connection in power bi and conditonal formating option is out)"
i cannot use that link or method, need a work around.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |