Dear Experts,
I am trying to make a timeline graph in PowerBI (Example below).
Data structure is as shown in the below table. I have manually assigned a position to each of the row. Now, when I insert a line grpah in BI with markers on and no line and error bars, i am getting almost similar graph as above with slight variation. For example, if i have multiple IDs for the same date, then in BI, the Position column is getting summed up (which I do not want). I need a separate dot for all the rows even if they are for a same date. Is it feasible to do this in BI?
| ID | Date | Position |
| 18442 | 01-01-2023 | 3 |
| 13832 | 05-01-2023 | 2 |
| 14419 | 09-01-2023 | -2 |
| 13868 | 11-01-2023 | 1 |
| 15708 | 12-01-2023 | 5 |
| 15151 | 27-01-2023 | -3 |
| 18432 | 01-02-2023 | 1 |
| 14427 | 03-02-2023 | -1 |
| 15658 | 09-02-2023 | -4 |
| 15666 | 23-02-2023 | 3 |
| 15674 | 23-02-2023 | 4 |
| 15675 | 23-02-2023 | 5 |
| 15676 | 23-02-2023 | 6 |
| 15677 | 23-02-2023 | 7 |
| 15678 | 23-02-2023 | 2 |
| 15679 | 23-02-2023 | 8 |
| 15680 | 23-02-2023 | 1 |
| 15681 | 23-02-2023 | 9 |
| 15682 | 23-02-2023 | 9.5 |
| 15683 | 23-02-2023 | 0.5 |
| 15724 | 25-03-2023 | -7 |
| 15725 | 25-03-2023 | -6 |
| 15727 | 25-03-2023 | -9 |
| 15729 | 25-03-2023 | -5 |
| 15730 | 25-03-2023 | -4 |
| 15731 | 25-03-2023 | -8 |
| 15732 | 25-03-2023 | -3 |
Thanks
Nitesh
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
