Conditional fomatting background colour

[Anonymous]

Hi all,

Need your help!

I have a table. and want to colour background of all row that have RFC date

what i have

SS	ITR PROGGRESS	PUNCH PROGRESS	RFC DATE
1	100	100	10/26/2020
2	70	100
3	50	70

what i want

SS	ITR PROGGRESS	PUNCH PROGRESS	RFC DATE
1	100	100	10/26/2020
2	70	100
3	50	70

thank you,

CL

[v-robertq-msft]

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.

[amitchandak]

@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