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.