Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BDSR
Regular Visitor

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

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:

BDSR_0-1716801305938.png

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 

BDSR_1-1716802111175.png

 

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 

1 ACCEPTED SOLUTION

the same with your data

gdelpuenteCinec_2-1716804402172.pnggdelpuenteCinec_3-1716804411226.pnggdelpuenteCinec_4-1716804424576.png

 

View solution in original post

3 REPLIES 3
BDSR
Regular Visitor

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 NameStart Sequence End Sequence
A110
48
C815

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

 

 

the same with your data

gdelpuenteCinec_2-1716804402172.pnggdelpuenteCinec_3-1716804411226.pnggdelpuenteCinec_4-1716804424576.png

 

a quick solution can be to use the stacked bar chart

gdelpuenteCinec_0-1716803377454.png

 


coloring the blocks preceding the activity as the background

gdelpuenteCinec_1-1716803404206.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.