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 Hmm, so Calendar[Date] is used in you x-axis?

Anonymous

Not applicable

5 years ago

I used Week but this made up based on date like below

Community Champion

5 years ago

Anonymous I think it was a syntax error on my part, corrected below.

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 got it!
but can it become a line??
Greg_Deckler
Community Champion
5 years ago
Anonymous Unfortunately no, haven't found a way to draw vertical lines on line charts yet. The Analytics pane only allows horizontal lines. Unless...you want to create a bunch of those measures, each with a different value that is returned, so think 10 of those measures that return values from 1 to 10 each, then they would show up stacked vertically on the graph. Maybe create one for every 2000? 😞