https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting-with-a-Goal/m-p/1156163#M24137 <P>Is there a way to create a line and column chart where the color of the column is based on whether or not they met the dynamic goal, which is the line? The goal will change per person (column) based on how much time they have worked within the function, which is where I’m getting stuck. I’ve found videos of how to do it with a static goal, but not a dynamic one.</P> Fri, 12 Jun 2020 15:30:02 GMT Anonymous 2020-06-12T15:30:02Z https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting-with-a-Goal/m-p/1156163#M24137 <P>Is there a way to create a line and column chart where the color of the column is based on whether or not they met the dynamic goal, which is the line? The goal will change per person (column) based on how much time they have worked within the function, which is where I’m getting stuck. I’ve found videos of how to do it with a static goal, but not a dynamic one.</P> Fri, 12 Jun 2020 15:30:02 GMT https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting-with-a-Goal/m-p/1156163#M24137 Anonymous 2020-06-12T15:30:02Z https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting-with-a-Goal/m-p/1156615#M24141 <P>Check this out</P><P>&nbsp;</P><P><A href="https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2020-feature-summary/#_Line_chart" target="_blank">https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2020-feature-summary/#_Line_chart</A></P><P>&nbsp;</P><P>it's not exactly what you want but I think it is only a matter of time before they implement conditional formatting on that.</P> Fri, 12 Jun 2020 20:09:31 GMT https://community.fabric.microsoft.com/t5/Developer/Conditional-Formatting-with-a-Goal/m-p/1156615#M24141 lbendlin 2020-06-12T20:09:31Z