Format matrix columns into bands of colours in Power BI

[@brianjulius6401]

Totally agree with you that this should be easier in Power BI, but really clever implementation and great explanation.

[@mardithpascua8112]

Hi, New to PowerBI, I watched your video however, in my PowerBI Desktop. there's no Conditional formatting in the property.

[@PowerBIFerryTales]

It may be because of the updated format panel. It is called Cell Elements now.

[@mardithpascua8112]

@@PowerBIFerryTales is it possible to have a different colors per Column? Like for example
I have:
Week 1 | Week 2 | Week 3 | Week 4
then these column header and their rows should have different colors

[@pavankumar-hw6zb]

Great trick

[@SergiyVakshul]

I see that your will have a problem if apply a filter for MON, WED, FRI, SUN only. To get around it I'd use something similar to the following: ODD_color =
IF(
ISODD(
RANKX(
ALLSELECTED('Date'[Date]),
CALCULATE(SELECTEDVALUE(('Date'[Date])))
)
),
"#EFEFEF"
)

[@PowerBIFerryTales]

Nice idea, thanks for posting it. 👍

[@antique-bs8bb]

I'm guessing there is a reason, but do you really need to make your colouring measure = [a measure] ?
Why not just 0 or 1 ?
Or even just use the M-coded 'Date'[Odd or Even] - or at least colour measure = MAX('Date'[Odd or Even]) ?