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

Could anybody advise me? 

 

thanks,

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.

4 Replies

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

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

    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.