Forum Discussion
Highlight current week using conditional column
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.
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!
4 Replies
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!
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 datesJustas4478 - 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:
