How to create a line chart which is both solid and dotted

[deepanwita25]

Hello All, I have been given the task to create a line chart. The line chart will contain Actual and Predicted Values. The Forecasted/Predicted Values need to be represented by a dotted line while the actual values will have a solid line..I need to achieve this feature in a line graph..What do you recommend how i do it? There is something called Charticulator that I am not very much aware of? will that work for this or I can do it simply with another chart from the marketplace..Please help me here

[Anonymous]

Hi @deepanwita25 ,

Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.
If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.

Best Regards,
Stephen Tao

[Fowmy · Accepted solution]

@deepanwita25 

In a line chart, add the Actual and Forecast sales, 

On the properties pabe, select the line and the Forecast measure, then change the line style to dotted 

[deepanwita25]

Thank you so much @Fowmy  for your solution. Your sol inspired me to create the below.

I created 2 measures where one is the Actual and the Other is Actual&Forecast.

In Actual&Forecast the logic is If Actual value not available then give me forecasted values.

The arrangement of the 2 measures is also important in the Y-axis field is also important. Keep Actual&Forecast on the top and then Actual values.

Then you get the following: