cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Amir851 Frequent Visitor
Frequent Visitor

Dynamic date vertical reference line or a dot in a line chart

How Can I add a dynamic or constant date vertical reference line in a line chart , where x axis will be date value, y will be actual component value and after that date reference line, color of that particular line should be changed to red. I know how to do this in Tableau but I want this in Power BI

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Dynamic date vertical reference line or a dot in a line chart

hi, @Amir851

A vertical reference line is not available now. 

To work around this requirement, you can try to use a combination chart.

  1. Create a "line and stacked column chart"
  2. Put column [date] into shared axis and put [values] into line values.
  3. Create a measure like this, put this measure into column values.

Measures can be:

Measure 2 = 
IF(SELECTEDVALUE('Table'[Date])=TODAY()-15,1)

Result;

7.JPG

 

Best Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Dynamic date vertical reference line or a dot in a line chart

hi, @Amir851

A vertical reference line is not available now. 

To work around this requirement, you can try to use a combination chart.

  1. Create a "line and stacked column chart"
  2. Put column [date] into shared axis and put [values] into line values.
  3. Create a measure like this, put this measure into column values.

Measures can be:

Measure 2 = 
IF(SELECTEDVALUE('Table'[Date])=TODAY()-15,1)

Result;

7.JPG

 

Best Regards,

Lin

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.