Additional functionality for a graph showing a vertical line and a text

[some_analyst]

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

[OwenAuger · Accepted solution]

Hola @some_analyst

Yes, you can create a constant line of the X-axis with a date returned by a measurement.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#use-the-analytics-...

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
    Result

Then add a reference line of type Constant line on the X-axis, with the value set in the measure (by clicking fx).