combining two line charts into a single chart without aggregation on the secondary axis

[Anonymous]

I am trying to display two lines on the same chart using the secondary Y-axis. However, when I add the second line to the chart (on the secondary axis), the values are getting aggregated, which is not what I want. Both lines are plotted against the same Y-axis.

How can I plot these two metrics on the same chart while ensuring that the secondary axis values are displayed correctly (without aggregation)?

Here are the screenshots of the current setup and the issue I’m trying to solve:

Any guidance on how to fix this would be appreciated!



data sample

%GT Histogram Arrival Delay	rounded_scheduled_TAT_min
0.38%	30
11.49%	40
10.19%	50
17.55%	60
8.76%	70
4.88%	80
9.88%	90
4.18%	100
4.05%	110
3.62%	120
3.20%	130
2.13%	140
1.68%	150
1.43%	160
1.49%	170
1.79%	180
1.55%	190
1.11%	200
0.93%	210
0.97%	220
0.97%	230
1.51%	240
1.28%	250
1.32%	260
1.03%	270
1.42%	280
0.78%	290
0.41%	300

%GT Histogram Arrival Delay	rounded_actual_TAT_min
0.98%
0.70%	30
7.17%	40
16.61%	50
13.50%	60
9.54%	70
7.91%	80
6.20%	90
5.45%	100
4.04%	110
3.64%	120
2.61%	130
2.36%	140
1.79%	150
1.58%	160
1.61%	170
1.61%	180
1.38%	190
1.09%	200
1.13%	210
1.24%	220
1.14%	230
1.15%	240
1.21%	250
1.01%	260
1.19%	270
1.10%	280
0.91%	290
0.15%	300

[Anonymous]

Sure HYG a sample data and the both curves have the same column whish is the %GT Histogram Arrival Delay

and the other 2 columns are 

I am attempting to visualize the difference between the scheduled and actual values.

[lbendlin]

second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Updated the original post