Forum Discussion
Line Chart plots everything in one line?
I have tried everything I can think of to fix this...but in my line chart, Power BI keeps graphing each set on the same line, even with a legend?
The X-Axis is Week.Day and is of type "decimal number". So I don't understand why I am only getting one plot line?
Hi rmcgrath
Based on the data you attached, those lines sit on different time axes with no day-level overlap.
That means they won’t stack one beneath the other—they’ll appear one after the other, as in the screenshot.
(The only exception would be if you’re comparing day-of-week trends independent of the specific week.)
I’ve also included a PBIX file with an example so you can compare your steps to mine and fix whatever needs adjustme
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Hi rmcgrath
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523GroupCode PctLiv AgeDays AgeRndWks DaysRemain WeekDay MLL10001 95.44% 264 38 5 38.5 MLL10001 95.40% 265 38 6 38.6 MLL10001 95.39% 266 38 0 38 MLL10001 95.35% 267 38 1 38.1 MLL10001 95.33% 268 38 2 38.2 MLL10001 95.31% 269 38 3 38.3 MLL10001 95.28% 270 39 4 39.4 MLL10001 95.25% 271 39 5 39.5 MLL10001 95.22% 272 39 6 39.6 MLL10001 95.21% 273 39 0 39 MLL10001 95.18% 274 39 1 39.1 MLL10001 95.15% 275 39 2 39.2 MLL10001 95.12% 276 39 3 39.3 MLL10001 95.10% 277 40 4 40.4 MLL10001 95.08% 278 40 5 40.5 OVL23T08 99.87% 125 18 6 18.6 OVL23T08 99.86% 126 18 0 18 OVL23T08 99.85% 127 18 1 18.1 OVL23T08 99.84% 128 18 2 18.2 OVL23T08 99.84% 129 18 3 18.3 OVL23T08 99.83% 130 19 4 19.4 OVL23T08 99.82% 131 19 5 19.5 OVL23T08 99.80% 132 19 6 19.6 OVL23T08 99.80% 133 19 0 19 OVL23T08 99.79% 134 19 1 19.1 OVL23T08 99.78% 135 19 2 19.2 OVL23T08 99.78% 136 19 3 19.3 OVL23T08 99.78% 137 20 4 20.4 OVL23T08 99.76% 138 20 5 20.5 OVL23T08 99.75% 139 20 6 20.6 The expected outcome would be a line for each set (MLL10001 and OVL23T08), with PctLiv on the Y-Axis and WeekDay on the X-Axis. Special Note: WeekDay is the Week number separated with a "." and then the day. So, for example, 20.6 would represent the 20th week, Day 6.
Hi rmcgrath
Based on the data you attached, those lines sit on different time axes with no day-level overlap.
That means they won’t stack one beneath the other—they’ll appear one after the other, as in the screenshot.
(The only exception would be if you’re comparing day-of-week trends independent of the specific week.)
I’ve also included a PBIX file with an example so you can compare your steps to mine and fix whatever needs adjustme
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
