Line Chart: Solid lines up to certain dates and then Dotted line

[jnnilesh29]

Hello guys,

I have a line chart as follows and wondering if I can get solid green line (Achieved progress) up to a certain date (let's say November 30, 2021) and then followed by dotted green line (Forecast progress)?

Any help is appreciated.

Thanks,

Nilesh

[Anonymous · Accepted solution]

Hi @jnnilesh29 

Please correct me if I wrongly understand your question .

In your sample, use a certain date 2021-11-30 as the separation point , the value of Achieved progress display as a solid green line and the value of Forecast progress display as a dotted green line .You can realize the requirements by creating measures .I create a sample , you can make a reference .

(1)Create two measures to return the value of Achieved progress before the certain date and the value of Forecast progress after the certain date .

achieved progress before = CALCULATE(SUM('Table'[Achieved progress]),FILTER('Table','Table'[Date]<=DATE(2021,11,30)))

forecast progress after = CALCULATE(SUM('Table'[Forecast progress]),FILTER('Table','Table'[Date]>=DATE(2021,11,30)))

(2)Add a Line chart ,and put these two measures in Values and Secondary values ,date in Axis .

(3)In visual format , turn on Customize series in Shapes . Choose the measure [forecast progress after] and set the Line style to Dotted . Change the line color in Data colors . 

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

[themistoklis]

@jnnilesh29 

You should create 2 measures per line (one for solid and one for dotted).

See link below:

https://community.powerbi.com/t5/Desktop/Line-Chart-Is-it-possible-to-have-half-of-the-chart-as-soli...

[jnnilesh29]

Hi @themistoklis ,

I did create two measure per the link you shared. However, it is giving me some weird results. Please see the below graph and measures: 

Please help.