Conditional fomatting background colour

Anonymous , there is no row conditional formatting. You have to do it for all the columns. If needed create a color measure and use that in conditional formatting using "Field value"

 

example

Color sales = if(AVERAGE(Sales[Sales Amount])<170,"green","red")
Color Year = if(FIRSTNONBLANK('Table'[Year],2014) <=2016,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

refer

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Hey, @colourfullife

According to your requirement, you can follow in my footsteps:

1.Create a calculated column:

Flag = 
IF(
    [RFC DATE]=BLANK(),
    1,
    0)

2. Create a table chart and place columns in your table, and select conditional formatting, like this:

3. Set like this, and do the same for the other three columns [ITR PROGGRESS], [PUNCH PROGRESS], [SS]

And you can get whatever you want, like this:

You can download my test pbix file here

Best regards

Qin Community Support _Robert Team

If this post helps,then consider Accepting it as the solution to help other members find it faster.