Line charts: Dual Axis, single element and line not running to the end of the period

[G_Whit-UK]

Hi

I've current got a line chart which reflects the count of X items split by three geographical regions over a periof of time.  Here is an example:

I've been asked to make the following changes:

1. Dual Axis:  Reflect the APAC & EMEA lines on a secondary axis.  I am not sure how this can be done seeing as seeing as the chart uses a single element;
2. Extend the APAX line to the end of the data range:  The APAC data never had any data for the last few days (zero count), hence the line stopping.  How can this be extended to the end of the date range.

Thanks

[amitchandak · Accepted solution]

@G_Whit-UK , You can not use the secondary axis for the legend split. You need to create three measures one for each region and use them as per need

[G_Whit-UK]

Thanks for the tip about the measures, but how can I extend the APAC line when there is no data to count? I'd like the line to extend to the end of the date range, but reflect a value of zero.