Forum Discussion
Additional functionality for a graph showing a vertical line and a text
Is there a way to work with a line graph and add a vertical line which shows the current week and a label for it which says "This week", like in the picture below - so far I have it a manual line, but I would like it dynamic as weeks progress
Hola @some_analyst
Yes, you can create a constant line of the X-axis with a date returned by a measurement.
A small example is attached.
For example, create this measure that determines the start date of the week based on the TODAY() function. You can use any other logic you want to determine your desired date:
Week Start Date = VAR TodayDate = TODAY () VAR Result = TodayDate - WEEKDAY ( TodayDate, 3 ) RETURN ResultThen add a reference line of type Constant line on the X-axis, with the value set in the measure (by clicking fx).
1 Reply
Hola @some_analyst
Yes, you can create a constant line of the X-axis with a date returned by a measurement.
A small example is attached.
For example, create this measure that determines the start date of the week based on the TODAY() function. You can use any other logic you want to determine your desired date:
Week Start Date = VAR TodayDate = TODAY () VAR Result = TodayDate - WEEKDAY ( TodayDate, 3 ) RETURN ResultThen add a reference line of type Constant line on the X-axis, with the value set in the measure (by clicking fx).