Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 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())
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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())
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.