Forum Discussion
Colouring this week x axis in graph
Hi Masters, I want to colour W38 to show which week we are like below. Is it possible? any advice would be much appreciated. thank you, CL
Anonymous Oh, wait, syntax error, missing )
Measure = VAR __Date = MAX('Table'[Date]) RETURN IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())
Greg_Deckler oh.. that's too bad.... okay thank you so much for your help in anyways! 🙂
Anonymous Sorry we couldn't get there completely in the end, but if this at least gets you something, mark it as an answer so others can benefit! 🙂