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

Hi Greg_Deckler for how, it shows 2019-38 and 2020-38 for dot..

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous Hah!, didn't think about that! OK, that's easy to fix:

Measure = 
  VAR __Date = MAX('Table'[Date])
RETURN
  IF(WEEKNUM(__Date) = WEEKNUM(TODAY() && YEAR(__Date) = YEAR(TODAY()),1,BLANK())

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Greg_Deckler  oh.. that's too bad.... okay thank you so much for your help in anyways! 🙂

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    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())
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi  Greg_Deckler  thanks for your reply.

    I honestly have no idea of this dax..

     

    this time, it didn't appear? 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous Hmm, so Calendar[Date] is used in you x-axis?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Greg_Deckler 

     

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

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

    Greg_Deckler  got it!

    but can it become a line??

     

  • Greg_Deckler's avatar
    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?  😞

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous Sorry we couldn't get there completely in the end, but if this at least gets you something, mark it as an answer so others can benefit! 🙂