Forum Discussion
How to create a line chart which is both solid and dotted
Anonymous
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
Super UserAnonymous
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
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: