Visualization on a timeline without dates

[Anonymous]

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;

[Nicolas180]

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.

[v-juanli-msft]

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]

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