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 

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.