Single line in line chart with dotted and solid

[atasgao]

Hello Everyone, 

I am trying to create a line which show my actual values - solid line and forecaste value - dotted line. Same as the picture below.

But when I create it, it is having a gap same as the below picture. 

Would like to know how can I fix the issue. 

Thanks in advance

Thanks, 

Aakanksha 

[Anonymous · Accepted solution]

Hi  @atasgao ,

I created some data:

Here are the steps you can follow：

1. Create measure.

M_ForeastAmountRemainingMonth =
SUM('Table'[ForeastAmountRemainingMonth])

M_ActualsAmountYTD = 
SUM('Table'[ActualsAmountYTD])

Measure-ActualsAmountYTD =
IF(
    MAX('Table'[date].[MonthNo])<10&&MAX('Table'[date].[MonthNo])>=9,CALCULATE(SUM('Table'[ForeastAmountRemainingMonth]),FILTER(ALL('Table'),[date].[MonthNo]=10)),[M_ActualsAmountYTD])

2. Place [M_ForeastAmountRemainingMonth] and [Measure-ActualsAmountYTD] in the line chart.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@atasgao , Create a measure (only for forecast visual line) to have actual of last month added to forecast

or even forecast line can be actual + forecast, in-display it will display like you want