Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Visualization on a timeline without dates

Hi everyone!

I have a table with different users completing actions.

The users can start and end the action at different time stamps. 

 

I would like to compare how long each user takes to complete an action to each other and represent it in a visualization.

 

Could anyone offer advice as to what visualizations there are available (if any) in Power BI to use for this problem?

 

Thus far, I have done the following, but I suspect my logic is over-complicated:

1. Order dates by user from earliest till latest

2. Day user started action= Assign day 0 to earliest date of user, day 0+1 to (earliest date) +1, etc.

3. Date taken to complete action of user = (end date - start date)

4. date user ended action= (day user started action) + (date to complete action)

5. Visualize on a timeline

 

 

This is the code in SAS, but I would like to do it in PowerBI if possible:

proc sort data=a;by about date;run;

data b;set a;

by about date;

retain time 0;

ldate=lag(date); *lag function carries previous date over to next time period;

dif_date=date-ldate; *count days not submitted;

if first.about then time=1; *maketime=1 for each new speller(about);

else time=time+dif_date;

run;

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi Anonymous 

    Assume your table is like

    Create two calculated columns

    start date = CALCULATE(MIN(Sheet2[date]),ALLEXCEPT(Sheet2,Sheet2[user]))
    
    end date = CALCULATE(MAX(Sheet2[date]),ALLEXCEPT(Sheet2,Sheet2[user]))

    You could also use a "Gantt" visual.

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi there

       

      Thank you for the response Maggie.

       

      This is not 100% the problem I'm having, hence why I did not accept it as a solution :).

       

      I would ideally like to have no dates available on the visual, just "week 1, week 2,...".

       

      I'm not sure if I'm misunderstanding your proposed solution, but it does not fulfill that need,

      thank you for the help though.

       

      Kind regards

  • I was wondering if anybody had found a solution to this tocpic. I am trying to create a visual where months are not calendar month, but a time periode that could be numbered 1 to 18, the idea is to stack up multiple projects with various timeline against one an other.