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())
Anonymous I don't see where you can set the color of a line based on a formula yet. So like:
Measure = IF(WEEKNUM(MAX('Table'[Date]))=WEEKNUM(TODAY()),1,BLANK())Hi Greg_Deckler
X axis in the graph, there are Weeks,
2020-21, 2020-22, 2020-23, 2020-24 . . . . .
i want to colour 2020-38.
Anonymous Right, still no conditional formatting for that. You could add a new line that only displays on the current week, so that it shows as a dot and set it to a value of 1 perhaps. Then that would indicate current week.
Greg_Deckler, That's a good idea!
can you let me know what i should do if i'd like to have the line?
thanks,
CL
Anonymous Thinking:
Measure = IF(WEEKNUM(MAX('Table'[Date]))=WEEKNUM(TODAY()),1,BLANK())