Forum Discussion

Arnault_'s avatar
Arnault_
Resolver III
8 years ago

Time stamps visual

 Dear All,

 

I am trying to represent a leadtime made of several segments (steps). I have a table with row data where every date is registered in separated columns. It is then quite simple to calculate the lead time for each segment as well as the total lead time.

 

I am looking for a nice visual to display this lead time in PBI. As you will see in the picture, I found a way to do that, but if you have better ideas, I would like you to advise me. Thank you in advance.

 

Here is below the "lead time" represented, as you can see there are different segments (order cycle lead time):

Here is the table with the row data ( 1 date = 1 event = 1 column... then other columns not visible in the picture allow to calculate diffences between 2 dates => 1 column for each segment):

 

 

And finally the chart I have used so far:

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Arnault_,

     

    Current power bi seems not contains any visuals who can suitable for your requirement(I also check on custom visuals but not luck).
    For your scenario, I'd like to suggest you to use r visual with r script or share this to ideas forum.

    R script and R visuals in Power BI


    Regards,

    Xiaoxin sheng

    • Arnault_'s avatar
      Arnault_
      Resolver III

      Hi Anonymous and thank you for your reply.