Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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

5 years ago

Anonymous Oh, wait, syntax error, missing )

Measure = 
  VAR __Date = MAX('Table'[Date])
RETURN
  IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())

Community Champion

5 years ago

Anonymous Oh, wait, syntax error, missing )

Measure = 
  VAR __Date = MAX('Table'[Date])
RETURN
  IF(WEEKNUM(__Date) = WEEKNUM(TODAY()) && YEAR(__Date) = YEAR(TODAY()),1,BLANK())

Anonymous

Not applicable

5 years ago

Greg_Deckler oh.. that's too bad.... okay thank you so much for your help in anyways! 🙂

Greg_Deckler
Community Champion
5 years ago
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! 🙂