Highlight current week using conditional column

[Justas4478]

Hi, I have chart that shows holiday hours booked by weeks.

I want to highlight current week using the coditional formatting option.
But the only way I see is by writing measure that checks if it is current week

I had something similar done for check if anyone is on holiday today, but I cant work out how to change it to check for this week instead of today.

IF(MAX('Holiday Data'[Start Date])=TODAY(),0,1)

[mark_endicott · Accepted solution]

@Justas4478 - Try this:

VAR _StartOfWeek = TODAY() - WEEKDAY( TODAY(), 2 ) + 1 

RETURN
IF(MAX('Table'[Date Column])= _StartOfWeek,1,0)

It will proivde a 1 if your date column matches the _StartOfWeek variable.

If this helps you, please accept as the solution so others with the same issue can find the answer!

[Justas4478]

I tried it and it doesnt seam to work when I put it in conditional rule.

If I change it to 1 instead of 0 it the colors all dates

[mark_endicott]

@Justas4478 - The DAX is correct, but you cannot apply it to the Values of the axis lables, I suggest you apply it to the Column colour instead. This will highlight the current week in a better way:

[Justas4478]

Yea that worked, thanks