Forum Discussion

NiteshS's avatar
NiteshS
Helper I
3 years ago

Timeline graph in PowerBI

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?

 

IDDatePosition
1844201-01-20233
1383205-01-20232
1441909-01-2023-2
1386811-01-20231
1570812-01-20235
1515127-01-2023-3
1843201-02-20231
1442703-02-2023-1
1565809-02-2023-4
1566623-02-20233
1567423-02-20234
1567523-02-20235
1567623-02-20236
1567723-02-20237
1567823-02-20232
1567923-02-20238
1568023-02-20231
1568123-02-20239
1568223-02-20239.5
1568323-02-20230.5
1572425-03-2023-7
1572525-03-2023-6
1572725-03-2023-9
1572925-03-2023-5
1573025-03-2023-4
1573125-03-2023-8
1573225-03-2023-3

 

Thanks

Nitesh

No RepliesBe the first to reply