Forum Discussion
combining two line charts into a single chart without aggregation on the secondary axis
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 |
4 Replies
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/1447523second 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
