HelloI am trying to reproduce the following chart in Power BI: The chart shows the running sum of the measure by each product across time. The x axis has the total days since the first datapoint was recorded to each product. A sample of the dataset for this report in PBI looks like this: ProductIndexRunningTotalAUIGI_1_202202AUIGI_1_202213AUIGI_1_202224AUIGI_1_202236AUIGI_1_202247AUIGI_1_202258AUIGI_1_202269AUIGI_1_2022710AUIGI_1_2022811AUIGI_1_2022912AUIGI_1_20221013AUIGI_1_20221115AUIGI_1_20221216AUIGI_1_20221317AUIGI_1_20221418AUIGI_1_20221519AUIGI_1_20221621AUIGI_1_20221723AUIGI_1_20221824AUIGI_1_20221925AUIGI_1_20222026AUIGI_1_20222127AUIGI_1_20222228AUIGI_1_20222329AUIGI_1_20222430AUIGI_1_20222531AUIGI_1_20222632AUIGI_1_20222733AUIGI_1_20222835AUIGI_1_20222936AUIGI_1_20223037AUIGI_1_20223138AUIGI_1_20223241AUIGI_1_20223343AUIGI_1_20223445AUIGI_1_20223546AUIGI_1_20223648AUIGI_1_20223750AUIGI_1_20223854AUIGI_1_20223957AUIGI_1_20224060AUIGI_1_20224161AUIGI_1_20224262AUIGI_1_20224364AUIGI_1_20224465AUIGI_1_20224567AUIGI_1_20224669AUIGI_1_20224771AUIGI_1_20224872AUIGI_1_20224974AUIGI_1_20225076AUIGI_1_20225177AUIGI_1_20225279AUIGI_1_20225381AUIGI_1_20225483AUIGI_1_20225584AUIGI_1_20225685AUIGI_1_20225786AUIGI_1_20225887AUIGI_1_20225988AUIGI_1_20226089AUIGI_1_20226190AUIGI_1_20226291AUIGI_1_20226392DELTA202202DELTA202213DELTA202224DELTA202236DELTA202247DELTA202258DELTA202269DELTA2022710DELTA2022811DELTA2022912DELTA20221013DELTA20221115DELTA20221216DELTA20221317DELTA20221418DELTA20221519DELTA20221621DELTA20221723DELTA20221824DELTA20221925DELTA20222026DELTA20222127DELTA20222228DELTA20222329DELTA20222430DELTA20222531DELTA20222632DELTA20222733DELTA20222835DELTA20222936DELTA20223037DELTA20223138DELTA20223241DELTA20223343DELTA20223445DELTA20223546DELTA20223648DELTA20223750DELTA20223854DELTA20223957DELTA20224060DELTA20224161DELTA20224262DELTA20224364DELTA20224465DELTA20224567DELTA20224669DELTA20224771DELTA20224872DELTA20224974DELTA20225076DELTA20225177DELTA20225279DELTA20225381DELTA20225483DELTA20225584DELTA20225685DELTA20225786DELTA20225887DELTA20225988DELTA20226089DELTA20226190DELTA20226291DELTA20226392DELTA20226494DELTA202265100DELTA202266103DELTA202267104DELTA202268105DELTA202269108DELTA202270110DELTA202271111DELTA202272112DELTA202273113DELTA202274114DELTA202275116DELTA202276117DELTA202277118DELTA202278123DELTA202279126DELTA202280129DELTA202281131DELTA202282132DELTA202283133DELTA202284140DELTA202285142DELTA202286144DELTA202287145DELTA202288147DELTA202289151DELTA202290152DELTA202291161DELTA202292167DELTA202293168DELTA202294170DELTA202295176DELTA202296187DELTA202297201DELTA202298211DELTA202299238DELTA2022100256DELTA2022101261DELTA2022102270DELTA2022103275DELTA2022104277DELTA2022105278DELTA2022106281DELTA2022107282DELTA2022108283DELTA2022109286DELTA2022110287DELTA2022111289DELTA2022112291DELTA2022113293DELTA2022114294DELTA2022115295DELTA2022116297DELTA2022117300DELTA2022118301DELTA2022119302DELTA2022120303DELTA2022121305DELTA2022122306DELTA2022123308DELTA2022124309DELTA2022125310DELTA2022126311DELTA2022127312DELTA2022128314DELTA2022129315DELTA2022130316DELTA2022131317DELTA2022132318DELTA2022133319DELTA2022134321DELTA2022135322DELTA2022136323DELTA2022137324DELTA2022138325DELTA2022139326DELTA2022140327DELTA2022141328DELTA2022142329DELTA2022143330DELTA2022144331DELTA2022145332DELTA2022146333DELTA2022147334DELTA2022148336DELTA2022149337DELTA2022150338DELTA2022151339I tried using the Line chart visual but as you can see in the image below it only shows one line. The Product is in Legend, Index is the x-axis and Running Total is the y axis (aggregated as average) Here is the setup in PBI Any idea what to do here to break the line to show one line per Product?Thanks in advanceRodrigo

calloni The problem is wih your data, they are all the same please check below,

Forum Discussion

calloni

Helper I

2 years ago

Solved

Running Total Line Chart by Product

Hello

I am trying to reproduce the following chart in Power BI:

The chart shows the running sum of the measure by each product across time. The x axis has the total days since the first datapoint was recorded to each product.

A sample of the dataset for this report in PBI looks like this:

Product	Index	RunningTotal
AUIGI_1_2022	0	2
AUIGI_1_2022	1	3
AUIGI_1_2022	2	4
AUIGI_1_2022	3	6
AUIGI_1_2022	4	7
AUIGI_1_2022	5	8
AUIGI_1_2022	6	9
AUIGI_1_2022	7	10
AUIGI_1_2022	8	11
AUIGI_1_2022	9	12
AUIGI_1_2022	10	13
AUIGI_1_2022	11	15
AUIGI_1_2022	12	16
AUIGI_1_2022	13	17
AUIGI_1_2022	14	18
AUIGI_1_2022	15	19
AUIGI_1_2022	16	21
AUIGI_1_2022	17	23
AUIGI_1_2022	18	24
AUIGI_1_2022	19	25
AUIGI_1_2022	20	26
AUIGI_1_2022	21	27
AUIGI_1_2022	22	28
AUIGI_1_2022	23	29
AUIGI_1_2022	24	30
AUIGI_1_2022	25	31
AUIGI_1_2022	26	32
AUIGI_1_2022	27	33
AUIGI_1_2022	28	35
AUIGI_1_2022	29	36
AUIGI_1_2022	30	37
AUIGI_1_2022	31	38
AUIGI_1_2022	32	41
AUIGI_1_2022	33	43
AUIGI_1_2022	34	45
AUIGI_1_2022	35	46
AUIGI_1_2022	36	48
AUIGI_1_2022	37	50
AUIGI_1_2022	38	54
AUIGI_1_2022	39	57
AUIGI_1_2022	40	60
AUIGI_1_2022	41	61
AUIGI_1_2022	42	62
AUIGI_1_2022	43	64
AUIGI_1_2022	44	65
AUIGI_1_2022	45	67
AUIGI_1_2022	46	69
AUIGI_1_2022	47	71
AUIGI_1_2022	48	72
AUIGI_1_2022	49	74
AUIGI_1_2022	50	76
AUIGI_1_2022	51	77
AUIGI_1_2022	52	79
AUIGI_1_2022	53	81
AUIGI_1_2022	54	83
AUIGI_1_2022	55	84
AUIGI_1_2022	56	85
AUIGI_1_2022	57	86
AUIGI_1_2022	58	87
AUIGI_1_2022	59	88
AUIGI_1_2022	60	89
AUIGI_1_2022	61	90
AUIGI_1_2022	62	91
AUIGI_1_2022	63	92
DELTA2022	0	2
DELTA2022	1	3
DELTA2022	2	4
DELTA2022	3	6
DELTA2022	4	7
DELTA2022	5	8
DELTA2022	6	9
DELTA2022	7	10
DELTA2022	8	11
DELTA2022	9	12
DELTA2022	10	13
DELTA2022	11	15
DELTA2022	12	16
DELTA2022	13	17
DELTA2022	14	18
DELTA2022	15	19
DELTA2022	16	21
DELTA2022	17	23
DELTA2022	18	24
DELTA2022	19	25
DELTA2022	20	26
DELTA2022	21	27
DELTA2022	22	28
DELTA2022	23	29
DELTA2022	24	30
DELTA2022	25	31
DELTA2022	26	32
DELTA2022	27	33
DELTA2022	28	35
DELTA2022	29	36
DELTA2022	30	37
DELTA2022	31	38
DELTA2022	32	41
DELTA2022	33	43
DELTA2022	34	45
DELTA2022	35	46
DELTA2022	36	48
DELTA2022	37	50
DELTA2022	38	54
DELTA2022	39	57
DELTA2022	40	60
DELTA2022	41	61
DELTA2022	42	62
DELTA2022	43	64
DELTA2022	44	65
DELTA2022	45	67
DELTA2022	46	69
DELTA2022	47	71
DELTA2022	48	72
DELTA2022	49	74
DELTA2022	50	76
DELTA2022	51	77
DELTA2022	52	79
DELTA2022	53	81
DELTA2022	54	83
DELTA2022	55	84
DELTA2022	56	85
DELTA2022	57	86
DELTA2022	58	87
DELTA2022	59	88
DELTA2022	60	89
DELTA2022	61	90
DELTA2022	62	91
DELTA2022	63	92
DELTA2022	64	94
DELTA2022	65	100
DELTA2022	66	103
DELTA2022	67	104
DELTA2022	68	105
DELTA2022	69	108
DELTA2022	70	110
DELTA2022	71	111
DELTA2022	72	112
DELTA2022	73	113
DELTA2022	74	114
DELTA2022	75	116
DELTA2022	76	117
DELTA2022	77	118
DELTA2022	78	123
DELTA2022	79	126
DELTA2022	80	129
DELTA2022	81	131
DELTA2022	82	132
DELTA2022	83	133
DELTA2022	84	140
DELTA2022	85	142
DELTA2022	86	144
DELTA2022	87	145
DELTA2022	88	147
DELTA2022	89	151
DELTA2022	90	152
DELTA2022	91	161
DELTA2022	92	167
DELTA2022	93	168
DELTA2022	94	170
DELTA2022	95	176
DELTA2022	96	187
DELTA2022	97	201
DELTA2022	98	211
DELTA2022	99	238
DELTA2022	100	256
DELTA2022	101	261
DELTA2022	102	270
DELTA2022	103	275
DELTA2022	104	277
DELTA2022	105	278
DELTA2022	106	281
DELTA2022	107	282
DELTA2022	108	283
DELTA2022	109	286
DELTA2022	110	287
DELTA2022	111	289
DELTA2022	112	291
DELTA2022	113	293
DELTA2022	114	294
DELTA2022	115	295
DELTA2022	116	297
DELTA2022	117	300
DELTA2022	118	301
DELTA2022	119	302
DELTA2022	120	303
DELTA2022	121	305
DELTA2022	122	306
DELTA2022	123	308
DELTA2022	124	309
DELTA2022	125	310
DELTA2022	126	311
DELTA2022	127	312
DELTA2022	128	314
DELTA2022	129	315
DELTA2022	130	316
DELTA2022	131	317
DELTA2022	132	318
DELTA2022	133	319
DELTA2022	134	321
DELTA2022	135	322
DELTA2022	136	323
DELTA2022	137	324
DELTA2022	138	325
DELTA2022	139	326
DELTA2022	140	327
DELTA2022	141	328
DELTA2022	142	329
DELTA2022	143	330
DELTA2022	144	331
DELTA2022	145	332
DELTA2022	146	333
DELTA2022	147	334
DELTA2022	148	336
DELTA2022	149	337
DELTA2022	150	338
DELTA2022	151	339

I tried using the Line chart visual but as you can see in the image below it only shows one line. The Product is in Legend, Index is the x-axis and Running Total is the y axis (aggregated as average)

Here is the setup in PBI

Any idea what to do here to break the line to show one line per Product?

Thanks in advance

Rodrigo

General Comment

Fowmy
2 years ago
calloni
The problem is wih your data, they are all the same please check below,

11 Replies

Fowmy

Super User

2 years ago

calloni

In your sample data, the Running Total of each product is the same so they overlap, try to chagne the running total and make it slightly different, it will show as you expected with the current way you have set up the visual.

calloni

Helper I

2 years ago

Hi Fowmy

OMG I think something happened when copying the sample data from CVS here. Here is how it should be:

Delta product has 151 entries with final total of 339; AUIGI has 63 entries with final total of 92. Does it look better now?

Product	Index	RunningTotal
AUIGI_1_2022	0	2
AUIGI_1_2022	1	3
AUIGI_1_2022	2	4
AUIGI_1_2022	3	6
AUIGI_1_2022	4	7
AUIGI_1_2022	5	8
AUIGI_1_2022	6	9
AUIGI_1_2022	7	10
AUIGI_1_2022	8	11
AUIGI_1_2022	9	12
AUIGI_1_2022	10	13
AUIGI_1_2022	11	15
AUIGI_1_2022	12	16
AUIGI_1_2022	13	17
AUIGI_1_2022	14	18
AUIGI_1_2022	15	19
AUIGI_1_2022	16	21
AUIGI_1_2022	17	23
AUIGI_1_2022	18	24
AUIGI_1_2022	19	25
AUIGI_1_2022	20	26
AUIGI_1_2022	21	27
AUIGI_1_2022	22	28
AUIGI_1_2022	23	29
AUIGI_1_2022	24	30
AUIGI_1_2022	25	31
AUIGI_1_2022	26	32
AUIGI_1_2022	27	33
AUIGI_1_2022	28	35
AUIGI_1_2022	29	36
AUIGI_1_2022	30	37
AUIGI_1_2022	31	38
AUIGI_1_2022	32	41
AUIGI_1_2022	33	43
AUIGI_1_2022	34	45
AUIGI_1_2022	35	46
AUIGI_1_2022	36	48
AUIGI_1_2022	37	50
AUIGI_1_2022	38	54
AUIGI_1_2022	39	57
AUIGI_1_2022	40	60
AUIGI_1_2022	41	61
AUIGI_1_2022	42	62
AUIGI_1_2022	43	64
AUIGI_1_2022	44	65
AUIGI_1_2022	45	67
AUIGI_1_2022	46	69
AUIGI_1_2022	47	71
AUIGI_1_2022	48	72
AUIGI_1_2022	49	74
AUIGI_1_2022	50	76
AUIGI_1_2022	51	77
AUIGI_1_2022	52	79
AUIGI_1_2022	53	81
AUIGI_1_2022	54	83
AUIGI_1_2022	55	84
AUIGI_1_2022	56	85
AUIGI_1_2022	57	86
AUIGI_1_2022	58	87
AUIGI_1_2022	59	88
AUIGI_1_2022	60	89
AUIGI_1_2022	61	90
AUIGI_1_2022	62	91
AUIGI_1_2022	63	92
DELTA2022	0	2
DELTA2022	1	3
DELTA2022	2	4
DELTA2022	3	6
DELTA2022	4	7
DELTA2022	5	8
DELTA2022	6	9
DELTA2022	7	10
DELTA2022	8	11
DELTA2022	9	12
DELTA2022	10	13
DELTA2022	11	15
DELTA2022	12	16
DELTA2022	13	17
DELTA2022	14	18
DELTA2022	15	19
DELTA2022	16	21
DELTA2022	17	23
DELTA2022	18	24
DELTA2022	19	25
DELTA2022	20	26
DELTA2022	21	27
DELTA2022	22	28
DELTA2022	23	29
DELTA2022	24	30
DELTA2022	25	31
DELTA2022	26	32
DELTA2022	27	33
DELTA2022	28	35
DELTA2022	29	36
DELTA2022	30	37
DELTA2022	31	38
DELTA2022	32	41
DELTA2022	33	43
DELTA2022	34	45
DELTA2022	35	46
DELTA2022	36	48
DELTA2022	37	50
DELTA2022	38	54
DELTA2022	39	57
DELTA2022	40	60
DELTA2022	41	61
DELTA2022	42	62
DELTA2022	43	64
DELTA2022	44	65
DELTA2022	45	67
DELTA2022	46	69
DELTA2022	47	71
DELTA2022	48	72
DELTA2022	49	74
DELTA2022	50	76
DELTA2022	51	77
DELTA2022	52	79
DELTA2022	53	81
DELTA2022	54	83
DELTA2022	55	84
DELTA2022	56	85
DELTA2022	57	86
DELTA2022	58	87
DELTA2022	59	88
DELTA2022	60	89
DELTA2022	61	90
DELTA2022	62	91
DELTA2022	63	92
DELTA2022	64	94
DELTA2022	65	100
DELTA2022	66	103
DELTA2022	67	104
DELTA2022	68	105
DELTA2022	69	108
DELTA2022	70	110
DELTA2022	71	111
DELTA2022	72	112
DELTA2022	73	113
DELTA2022	74	114
DELTA2022	75	116
DELTA2022	76	117
DELTA2022	77	118
DELTA2022	78	123
DELTA2022	79	126
DELTA2022	80	129
DELTA2022	81	131
DELTA2022	82	132
DELTA2022	83	133
DELTA2022	84	140
DELTA2022	85	142
DELTA2022	86	144
DELTA2022	87	145
DELTA2022	88	147
DELTA2022	89	151
DELTA2022	90	152
DELTA2022	91	161
DELTA2022	92	167
DELTA2022	93	168
DELTA2022	94	170
DELTA2022	95	176
DELTA2022	96	187
DELTA2022	97	201
DELTA2022	98	211
DELTA2022	99	238
DELTA2022	100	256
DELTA2022	101	261
DELTA2022	102	270
DELTA2022	103	275
DELTA2022	104	277
DELTA2022	105	278
DELTA2022	106	281
DELTA2022	107	282
DELTA2022	108	283
DELTA2022	109	286
DELTA2022	110	287
DELTA2022	111	289
DELTA2022	112	291
DELTA2022	113	293
DELTA2022	114	294
DELTA2022	115	295
DELTA2022	116	297
DELTA2022	117	300
DELTA2022	118	301
DELTA2022	119	302
DELTA2022	120	303
DELTA2022	121	305
DELTA2022	122	306
DELTA2022	123	308
DELTA2022	124	309
DELTA2022	125	310
DELTA2022	126	311
DELTA2022	127	312
DELTA2022	128	314
DELTA2022	129	315
DELTA2022	130	316
DELTA2022	131	317
DELTA2022	132	318
DELTA2022	133	319
DELTA2022	134	321
DELTA2022	135	322
DELTA2022	136	323
DELTA2022	137	324
DELTA2022	138	325
DELTA2022	139	326
DELTA2022	140	327
DELTA2022	141	328
DELTA2022	142	329
DELTA2022	143	330
DELTA2022	144	331
DELTA2022	145	332
DELTA2022	146	333
DELTA2022	147	334
DELTA2022	148	336
DELTA2022	149	337
DELTA2022	150	338
DELTA2022	151	339

calloni
Helper I
2 years ago
BTW the chart image that I share has all 31 products on it in a single line with the exact same setup 😞

I hope we could share files / pbix here... it would be way more efficient

calloni
Helper I
2 years ago
The setup was indeed correct thanks for reviewing it... I fixed the data and now it works!

Again thanks so much!

Forum Discussion

Running Total Line Chart by Product

11 Replies

Related content

Running Totals

Running total

Waterfall Charts with running totals

Tableau to PowerBI Running Totals Issue

SumX? - cumulative running total