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<img /></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<img /></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</LI-USER>&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><img /></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