Line Chart plots everything in one line?

[rmcgrath]

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?

[rmcgrath]

GroupCode	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.

[Ritaf1983 · Accepted solution]

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

[Ritaf1983]

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/1447523