Forum Discussion
Justas4478
Post Prodigy
Post ProdigyHighlight 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...
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!
Justas4478Post Prodigy
Post ProdigyI 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
Super User
Super UserJustas4478 - 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