Forum Discussion

Anonymous's avatar
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

Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    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())

16 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 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
      5 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.

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        5 years ago

        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.