Unpivot -> Cumulative Graph

[Anonymous]

Hi,

I have data source which need unpivot then make a cumulative graph.

I did unpivot. but not sure how to deal with next..! I tried qucik measure for running total. but somehow it doesn't work...

Could anybody advise me? 

thanks,

[v-juanli-msft]

Hi @Anonymous 

Does my reply solve your problem?

If not, please let me know.

If it is sloved, it will be considered as closed.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-juanli-msft]

Hi @Anonymous 

I'm a little confused by the screenshot.

Could you use excel enter some example data to reproduce your original data table and the expected output?

Best Regards

Maggie

[Anonymous]

Hi,

The below table is what i have

I want to make a cumulative graph showing 3 lines (P/F/A) in Power BI.

thanks,

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

If your original data is like the table above, i can reproduce your problem and give a solution as below.

Import this data into Power BI

header1	header2	header3	7/20/2018	8/10/2018	8/24/2018	9/7/2018	9/21/2018	10/5/2018
overall	monthly	P	1	51	34	212	212	384.5
overall	monthly	F	5	44	40	150	303	388
overall	monthly	A	5	44	40	150	303	388
overall	Cumul	P	1	52	86	298	510	894.5
overall	Cumul	F	5	49	89	239	542	930
overall	Cumul	A	5	49	89	239	542	930

Select from column"7/20/2018"~column"10/5/2018" and "Umpivot columns", get two columns "Attribute" and "Value", change "Attribute" to "Date",

then create a line visual as below

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.