Custom column/bar chart that can have dual axis fields- Support Insights.

[BDSR]

Hi All,

I am in a very confused state in choosing a visual that can help us achieve the exact replica given by the end user.

We have a table where Plant field name, Start sequence and end sequence play a role to develop a visual.

The sample/ an example of the visual we need is as shown:

We need to develop the same in power BI.

Explanation for the visual on top: 

Basically there will be few plant fields where each one will have a start and end sequence number.

For example in the above case PF1- plant field has the start sequence as 1 and ends at sequence no -6, whereas PF2 has a start sequence at 6 and ends at 9 and so on.

Now the challenge for us is to create the replica of it using Power BI visuals. 

I have  the information in this way 

But I'm struggling to create the same kind of visual in Power BI. Tried using Gantt chart but it isn't helping in any way.

Can you please suggest few ways to achieve the visualization.
@Greg_Deckler , @dm-p @AlB @lbendlin @gdelpuenteCinec @Livia_Hernandez 

[BDSR]

Hi @gdelpuenteCinec , I didnot quite understand how you achieved that, But we have this kind of table with us and landing both the start and end sequence in one visual is the challenge.

Field Name	Start Sequence	End Sequence
A	1	10
B	4	8
C	8	15

When I filter out field A - I need to look at the bar showing as start sequence-1 and end sequence -10

[gdelpuenteCinec · Accepted solution]

the same with your data

[gdelpuenteCinec]

a quick solution can be to use the stacked bar chart

coloring the blocks preceding the activity as the background