Alternate color for each 3 rows

[Anonymous]

Hello All,

Below is  my data and I need to color (background) for each 3 rows.

Date 5/5/2021 and 5/7/2021 rows has to fill with backgorund blue colors. Rest background will be white.

Please suggest.

Date	Sample	P1	P2	P3
5/4/2021	1	10.41	10.31	10.14
5/4/2021	2	10.52	10.59	10.94
5/4/2021	3	10.69	10.41	10.37
5/5/2021	1	10.84	10.59	10.47
5/5/2021	2	10.2	10.01	9.88
5/5/2021	3	10.49	10.36	10.26
5/6/2021	1	10.27	10.61	10.35
5/6/2021	2	10.18	9.85	9.9
5/6/2021	3	10.78	10.94	10.28
5/7/2021	1	10.84	10.59	10.47
5/7/2021	2	10.2	10.01	9.88
5/7/2021	3	10.49	10.36	10.26

[amitchandak · Accepted solution]

@Anonymous , Create a measure like below and use that in conditional formatting using field value option

meausre =

if(max(Table[Date]) >= Date(2021,5,5)  && max(Table[Date]) <= Date(2021,5,7) , "Yellow", "White")

You have to use this measure for conditional formatting using the field value option, use for each column

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[amitchandak · Accepted solution]

@Anonymous , Create a measure like below and use that in conditional formatting using field value option

meausre =

if(max(Table[Date]) >= Date(2021,5,5)  && max(Table[Date]) <= Date(2021,5,7) , "Yellow", "White")

You have to use this measure for conditional formatting using the field value option, use for each column

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[Anonymous · Accepted solution]

Thank you @amitchandak . You are awesome. 

Some how I have given dummy data. Orignially I have two months data and need to color for each alternate date with yellow and while. So I have used below formula and it worked. Thanks again for your time.

Color = IF(ISEVEN(RANKX(ALLSELECTED('Table'),CALCULATE(SELECTEDVALUE(''[Date])),,ASC,Dense)) = TRUE(),1,0)