Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a table like this one:
| N° Plots | Planting Date |
| 80 | |
| 80 | |
| 80 | |
| 224 | |
| 224 | 24/9/2019 |
| 80 | 24/9/2019 |
| 224 | |
| 80 | |
| 80 | |
| 80 | |
| 88 |
and I want to create this line chart:
The objective is to show the advance (each date is a Planting Date) of the Planting Process as the percentage of Plots planted from the Total Plots to be planted, the last point shows thew empty plots (not planted yet).
I tried to do it with Power Bi using the Cumulative Total but I get something like this:
Can you help me with it?
Thanks
how does the chart relate to the data? It's not clear to me based on the description
Thanks for your reply and sorry for the misunderstood, the chart was not made with the data of the table, is just an example, I will try to explain it.
The chart shows the cumultative sums of planted plots up to the day when I make the report.
So, the first day (in the table 24/09/2019) the chart will show the percentage of the plots planted up to that day (204/1320 = 15 %). If another day I plant another 80 plots when I make the report the chart will show an advance in the planting process (284/1320 = 21.5 %). What remains to be planted (78.5 %) has to be show at the end of the plot indicating empty date.
I hope I have been clear enough, if not do not hesitate in contact me again.
Thanks a lot!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 17 | |
| 12 |