https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting/m-p/3382279#M43916 <P>Hello,</P><P>&nbsp;</P><P>I have a report where I am trying to compare the number of forecasted days for a project vs all the hours entered for each project.</P><P>&nbsp;</P><P>I've used a measure and I am trying to conditionally format the meausre so it shows green if the hours are less than the forecasted days and red if it is more.</P><P>&nbsp;</P><P>Can someone advise how to do this as I can't get it to work.</P><P>&nbsp;</P><P>Image attached for reference<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Conformat.JPG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/955978i78D39FB1623239EA/image-size/large?v=v2&amp;px=999" role="button" title="Conformat.JPG" alt="Conformat.JPG" /></span></P> Wed, 16 Aug 2023 08:30:42 GMT Anonymous 2023-08-16T08:30:42Z https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting/m-p/3382279#M43916 <P>Hello,</P><P>&nbsp;</P><P>I have a report where I am trying to compare the number of forecasted days for a project vs all the hours entered for each project.</P><P>&nbsp;</P><P>I've used a measure and I am trying to conditionally format the meausre so it shows green if the hours are less than the forecasted days and red if it is more.</P><P>&nbsp;</P><P>Can someone advise how to do this as I can't get it to work.</P><P>&nbsp;</P><P>Image attached for reference<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Conformat.JPG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/955978i78D39FB1623239EA/image-size/large?v=v2&amp;px=999" role="button" title="Conformat.JPG" alt="Conformat.JPG" /></span></P> Wed, 16 Aug 2023 08:30:42 GMT https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting/m-p/3382279#M43916 Anonymous 2023-08-16T08:30:42Z https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting/m-p/3382389#M43918 <P>@Anonymous</a>&nbsp;</P><OL><LI>Create a measure for calculating the difference</LI><LI>Navigate to visual properties ( Cell element)</LI><LI>Select the column which you want to format</LI><LI>Turn on Background color</LI><LI>Then fill the below window. The Red marked field should be your newly created measure.</LI></OL><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="nandukrishnavs_0-1692176413879.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/956012iAF79FD95DA81E8B8/image-size/large?v=v2&amp;px=999" role="button" title="nandukrishnavs_0-1692176413879.png" alt="nandukrishnavs_0-1692176413879.png" /></span></P><P>&nbsp;</P> Wed, 16 Aug 2023 09:00:57 GMT https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting/m-p/3382389#M43918 nandukrishnavs 2023-08-16T09:00:57Z