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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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