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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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