Visualize Connection Data

[Anonymous]

Hi All,

I'm trying to migrate some of my work from Tableau to PowerBI and I got stuck with visualizing connection data. The vis I want to replicate is:

The x-axis the time a user has connected to a machine, the length of the bar is the duration and the y-axis is the machine name. 
I'm quite new to Power BI and I haven't figured out a way how to do this, so all help wanted! I'm happy to use any custom visuals as long as they get the job done. 

Here is a sample data set:

MachineName	starttime	closetime	Duration (h)
MachineA	23/04/2020 21:38	23/04/2020 22:18	0.67
MachineA	23/04/2020 22:21	23/04/2020 23:15	0.89
MachineA	23/04/2020 23:15	23/04/2020 23:17	0.02
MachineA	28/04/2020 20:02	28/04/2020 20:05	0.05
MachineA	29/04/2020 19:49	29/04/2020 19:52	0.04
MachineA	29/04/2020 19:59	29/04/2020 20:01	0.04
MachineA	29/04/2020 20:02	29/04/2020 20:32	0.51
MachineA	6/05/2020 1:53	6/05/2020 1:58	0.08
MachineA	26/05/2020 18:53	26/05/2020 21:07	2.23
MachineA	4/06/2020 22:23	5/06/2020 1:07	2.74
MachineA	15/06/2020 19:36	15/06/2020 19:36	0.01
MachineB	21/04/2020 9:18	22/04/2020 8:44	23.43
MachineB	25/04/2020 7:23	25/04/2020 8:06	0.71
MachineB	25/04/2020 8:06	25/04/2020 8:09	0.05
MachineB	25/05/2020 8:39	26/05/2020 11:50	27.18
MachineB	5/06/2020 11:36	5/06/2020 11:36	0.01
MachineB	5/06/2020 14:40	6/06/2020 17:08	26.46
MachineB	10/05/2020 10:36	10/05/2020 11:48	1.19
MachineB	10/06/2020 13:58	10/06/2020 15:50	1.88
MachineB	10/06/2020 16:08	10/06/2020 18:41	2.55
MachineB	11/06/2020 9:59	11/06/2020 10:00	0.02
MachineB	11/06/2020 10:25	11/06/2020 10:30	0.09
MachineB	11/06/2020 10:33	11/06/2020 10:43	0.16

All hints/solutions much appreciated! 

Thanks!

[Anonymous · Accepted solution]

For anyone looking for the same in the future, there is a custom visual to do this called "as Timeline"

and it creates exactly what I described above:

[V-lianl-msft]

Hi @Anonymous ,

There is no such visualization for the time being.

Try to create a matrix ,then expand the Conditional formatting card and for Data bars, turn the slider to On.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt any visual with two text axis.

You can use a matrix. Create a color measure

example

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

Color Date =
var _min =minx(allselected(Date,Date[Year])
return
 Switch( true(),
 FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"lightgreen",
  FIRSTNONBLANK('Date'[Year],year(TODAY()))-_min =0 ,"blue",
 "red")

Then use it with conditional formatting using fields option

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values