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

Greg_Deckler 

 

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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 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's avatar
    Anonymous
    Not applicable
    6 years ago

    Greg_Deckler  got it!

    but can it become a line??

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 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?  😞