Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
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.
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.
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
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,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |