cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Unpivot -> Cumulative Graph

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,

step1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Unpivot -> Cumulative Graph

Hi @colourfullife 

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",

2.png

then create a line visual as below

1.png

 

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.

4 REPLIES 4
Community Support Team
Community Support Team

Re: Unpivot -> Cumulative Graph

Hi @colourfullife 

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

Re: Unpivot -> Cumulative Graph

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,

 

tt.PNG

Community Support Team
Community Support Team

Re: Unpivot -> Cumulative Graph

Hi @colourfullife 

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",

2.png

then create a line visual as below

1.png

 

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.

Community Support Team
Community Support Team

Re: Unpivot -> Cumulative Graph

Hi @colourfullife 

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.