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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Ballard-Atkins
Frequent Visitor

Scaling Gantt and Line Chart after slicing

We would like to demonstrate equipment breakdowns against process tank volumes by displaying our volume in a line chart with a Gantt aligned above; the Gantt displays our breakdowns. 

 

Consider the attached image; theTransfer Pump (failure) event should align with the indicated spot of the line graph. The end should very nearly coincide with the point at which the line graph descends again (they're a day apart).PowerBI.png

 

The line chart always scales nicely to the width of the visual, is there a way to scale the Gantt to the width of the visual? Setting the "Gantt Date type" under Format options doesn't accomplish the desired result; it just extends the Gantt to as long as it needs to be, either short of the visual width or longer.

1 ACCEPTED SOLUTION

You are correct; to scale the Gantt chart I have to edit the visual. It's scaled based on ticks; each tick is based on the number of milliseconds in the display unit (day, week, month, etc.). The axis is then set to the margin + number of ticks (among other things). 

 

So to scale my Gantt chart to my line chart (which does make sense in my use, because the failure correlates directly to the volume represented in the line chart) I have to make the ticks dynamic based on the visual display rather than time frame. 

 

If anyone's interested, I'll post the modified Gantt when I'm done.

View solution in original post

6 REPLIES 6
v-yuezhe-msft
Employee
Employee

@Ballard-Atkins,

I don’t think you can scale the Gantt to the width of the visual, the width of failure description in the Gannt is determined by the Duration.

Gantt chart and Line chart are two different charts, they use different scale type(Line chart uses Linear scale type ) and display report from different dimensions. In my opinion, it doesn’t make sense to scale the width of failure description in Gantt to match the width of points in Line Chart.

Regards,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

You are correct; to scale the Gantt chart I have to edit the visual. It's scaled based on ticks; each tick is based on the number of milliseconds in the display unit (day, week, month, etc.). The axis is then set to the margin + number of ticks (among other things). 

 

So to scale my Gantt chart to my line chart (which does make sense in my use, because the failure correlates directly to the volume represented in the line chart) I have to make the ticks dynamic based on the visual display rather than time frame. 

 

If anyone's interested, I'll post the modified Gantt when I'm done.

Hello Ballard,

 

I'd really like to use this modified visual.

May you respond here when you have it finished?

 

 

Thanks, Wallace

I haven't had more opportunity to work on this, but as we get back towards an analysis phase of our project, I might be able to revisit. If I get it created, I will share here.

OK, thanks.

@Ballard-Atkins,

You can post the modified Gantt and accept appropriate replies as answer, that way, other community members would easily find the solution when they get same issues.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors