Forum Discussion
timeline visual with multiple dates (milestones)
I am trying to build some visulations for a timeline but the dataset that I was given has multiple dates (columns) is it possible to build a timeline with having so many different dates? Most of the visuals I have attempted have a start and end date. Any suggestions on how to best visualize this data?
Not very clear how you want to use it. One way is unpivot and use it : https://radacad.com/pivot-and-unpivot-with-power-bi
Another way is to use each date in a trend individually. Map all of them with the same date dimension. Only one will be active. Use others using userelation .
Refer the usage at :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.
2 Replies
- amitchandak
Super User
Not very clear how you want to use it. One way is unpivot and use it : https://radacad.com/pivot-and-unpivot-with-power-bi
Another way is to use each date in a trend individually. Map all of them with the same date dimension. Only one will be active. Use others using userelation .
Refer the usage at :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.