Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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....
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
v-juanli-msft
Community Support
7 years ago

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.