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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sumitsingla12
Frequent Visitor

Gantt over Bar chart in Power BI similar to Tableau Dual Axis

Hey Champions,

 

Looking out for some help on creating something similar to shown below, In tableau it is very easy to show one measure using Bar chart and other measure using Gantt chart through Dual axis.

 

Wanted to do something similar in Power BI . But PowerBI does not provide any direct visual to achive the same.

Anybody with any workaround to achieve this kind of visual would be very helpful.

 

sumitsingla12_0-1713595184241.png

 

on x axis i would want show dates or category and then bar chart for one measure and want to use gantt for other measure.

 

3 REPLIES 3
lbendlin
Super User
Super User

In Power BI  you do this via a combo column and line chart.  Make the line invisible and make the markers look like horizontal lines.

Hi Ibendlin, Thanks for your response. I have tried that but it doesn't look good when data gets filtered out and lets say we have two bars .

In that case width of bars looks more compare to markers.

As shown below size of marker is quite small compare to bars.

Wondering if we have any other alternate to this.

 

sumitsingla12_0-1713791100210.png

 

 

I think this looks pretty good.

 

If you need something fancier look for custom visuals or create your own, for example with Deneb.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.