Multiple trend lines values on a line chart

[neta2059]

I am seeking help on how to create multiple trend lines on a line chart.

The requirement is to compare the three chapters below for 3 consecutive years.  The line chart in PowerBI does not allow me to compare the national data to the organizational data.

We created the below line chart in Excel and are trying to mimic it in PowerBI.  Any thoughts?

p.s. I have tried the Legend feild but it does not allow me to use two measures for comparisons.  Also, small multiples will not work for this requirement.  

Chart created in Excel: 

Chart created in PowerBI:

Thank you in advance. 

[v-jianpeng-msft]

Hi, @neta2059 

You'll need to put your x-axis categorical field in Legend:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[PabloVallejo12]

Why do you use two measures?
If you have your data in different tables, try to use summarize to get a only one

[neta2059]

Hi, 

We are comparing between two different data sets: "National" and "Organization".  It coming from two different tables.  See below.