Forum Discussion
Additional functionality for a graph showing a vertical line and a text
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).
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).