topic Re: combining two line charts into a single chart without aggregation on the secondary axis in Custom Visuals Development Discussion

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

Anonymous — Thu, 05 Dec 2024 07:20:00 GMT

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

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

lbendlin — Tue, 03 Dec 2024 15:01:03 GMT

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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

Anonymous — Wed, 04 Dec 2024 06:47:13 GMT

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.

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

lbendlin — Thu, 05 Dec 2024 02:36:05 GMT

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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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

Anonymous — Thu, 05 Dec 2024 07:20:25 GMT

Updated the original post