How to create dumbell chart using only default visuals

[PDG_VL]

Hi,

I'd like to create a (line) chart / dumbell chart. I tried to play around with error bars on barcharts but the result is not what I need due to the fact tha I need to use small multiples.

I'd like to visualize the lenght of events compared to a baseline, so "what and for how long" happened before a certain point (vertical dotted line on attached screenshot).

I have 2 graph created in PBI and I'd like to find the way to merge those into one - if possible. So, I'd like to show each event separately:

- where only the start and end point of an event are connected,

- separate events are not connected (so end point of previous event to the start point of an event is not connected)

- I'd like to use the same coloring if event types are the same.

Here is a little visual aid:

On the left: the result if I use the event index as legend (so events with different IDs represent diferent ranges or "dumbells" and are vertically separated). This is what I'd like to have but the colors are off due to the legend.

On th right: the same data but this time I used category as legend. The coloring is ok but events within the same category are connected. I'd like to remove teh connection whenever the dots are not representing the start and the end points of a single event.

Here is what I'd like to achieve:

Sample data:
Main_evet: in my actual data I have multiple main events and I'm going to use this attribute for Small multiples

Sub_Event_ID: I'd like to use this as the colorcode

Sub_Event_Index: I'd like to use this to separate the diferent line pieces

Start_or_end & Value columns: Where and for how long an event should be visualized.

Using the below data smaple as example this is how I bulit the charts above:

(x axis: Value;

y axis: Sum of Sub_Event_Index;

Legend:

a) left: Sub_Event_Index

b) right:  Legend: Sub_Event_ID )

Main_event	Sub_Event_ID	Sub_Event_Index	Start_or_End	Value
A	1	1	End	-9970
A	1	1	Start	-11138
A	1	2	Start	-9667
A	1	2	End	-4139
A	1	3	End	-1015
A	1	3	Start	-2636
A	1	4	Start	-1009
A	1	4	End	222
A	2	5	Start	-12659
A	2	5	End	-12648
A	2	6	Start	-6289
A	2	6	End	-4139
A	3	7	Start	-12325
A	3	7	End	-9970
A	3	8	Start	-9680
A	3	8	End	-4139
A	3	9	Start	-2647
A	3	9	End	-1015
A	3	10	Start	-1009
A	3	10	End	222

Does anyone have an idea how to achieve this - if possible? Thanks for the help!
PDG

[lbendlin]

is this any good?

[PDG_VL]

Hi @lbendlin, thanks for the help.

Unfortunately the version you sent is the same I alerady created and described under the first attached screeshot in my original post:

"On the left: the result if I use the event index as legend (so events with different IDs represent diferent ranges or "dumbells" and are vertically separated). This is what I'd like to have but the colors are off due to the legend."

So basically, the format is OK (separate lines for each event), the colouring is not (colorcoding should be based on Sub_Event_ID column.

Thanks,

PDG

[lbendlin]

colorcoding should be based on Sub_Event_ID column

That's a current feature gap.  Line colors are manual at the moment.