https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-modify-dax-measure-to-show-red-if-the-number-is-negative/m-p/3001554#M101364 <P>Power BI Community Good Day!</P><P>I am using the following measure in my dashboard as a label.</P><P>The number is negative. How can I modify the dax measure below to show red if the number is negative?&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>Amount Lost = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>metricsrevenuecustomer</SPAN><SPAN>[amount]</SPAN><SPAN>),</SPAN><SPAN>metricsrevenuecustomer</SPAN><SPAN>[revenue_type_lvl2]</SPAN><SPAN> =</SPAN><SPAN>"Lost"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Much appreciate your time.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you</SPAN></DIV><DIV>&nbsp;</DIV></DIV> Wed, 04 Jan 2023 16:53:30 GMT Anonymous 2023-01-04T16:53:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-modify-dax-measure-to-show-red-if-the-number-is-negative/m-p/3001554#M101364 <P>Power BI Community Good Day!</P><P>I am using the following measure in my dashboard as a label.</P><P>The number is negative. How can I modify the dax measure below to show red if the number is negative?&nbsp;</P><P>&nbsp;</P><DIV><DIV><SPAN>Amount Lost = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN>(</SPAN><SPAN>metricsrevenuecustomer</SPAN><SPAN>[amount]</SPAN><SPAN>),</SPAN><SPAN>metricsrevenuecustomer</SPAN><SPAN>[revenue_type_lvl2]</SPAN><SPAN> =</SPAN><SPAN>"Lost"</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Much appreciate your time.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you</SPAN></DIV><DIV>&nbsp;</DIV></DIV> Wed, 04 Jan 2023 16:53:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-modify-dax-measure-to-show-red-if-the-number-is-negative/m-p/3001554#M101364 Anonymous 2023-01-04T16:53:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-modify-dax-measure-to-show-red-if-the-number-is-negative/m-p/3001927#M101384 <P>You can use conditional formatting on the visual - see this guide for how to do that:&nbsp;<A href="https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column" target="_blank">https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column</A></P> Wed, 04 Jan 2023 21:27:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-modify-dax-measure-to-show-red-if-the-number-is-negative/m-p/3001927#M101384 vicky_ 2023-01-04T21:27:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-modify-dax-measure-to-show-red-if-the-number-is-negative/m-p/3002704#M101438 <P>Hi,&nbsp;Anonymous</LI-USER>&nbsp;</P> <P>&nbsp;</P> <P>Conditionally formatted measures need to be written separately.</P> <LI-CODE lang="markup">Color measure = IF([Amount Lost]&lt;0,"Red")</LI-CODE> <P>This is the Card view.</P> <P><img /><img /></P> <P>This is the Table view.</P> <P><img /><img /></P> <P>Is this the result you expect?</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Community Support Team _Charlotte</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG>helps</STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><EM>Accept it as the solution</EM></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> Thu, 05 Jan 2023 08:14:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-modify-dax-measure-to-show-red-if-the-number-is-negative/m-p/3002704#M101438 v-zhangti 2023-01-05T08:14:05Z