cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
VK_ Frequent Visitor
Frequent Visitor

Gantt chart with reference vertical lines

Expected chart:

 

image_2019_11_07T14_51_15_027Z.png

 y-axis: Tasks

x-axis: Dates

Reference lines(more than one): some specific dates

 

For plotting I'm using custom visual - Gantt (version-2.2.3.0) from power bi market place which is an open-source visual (code available at Github: https://github.com/microsoft/powerbi-visuals-gantt ). 

 

I'm able to plot the duration (start date to end date) of each Task but not able to plot reference lines (which are vertical lines as shown in the graph).

Sample Data:

Gantt Dataset.JPG

 

Any idea of how to achieve the above scenario will be helpful. Thanks in advance.

@ganttchart @customvisual 

@Greg_Deckler  @v-danhe-msft @v-chuncz-msft  @GuyInACube @datanaut 

 

3 REPLIES 3
v-evelk Senior Member
Senior Member

Re: Gantt chart with reference vertical lines

Hello,

 

Gantt has got Milestones bucket to set up vertical lines.
You can look through standard report to figure out how to use them.

 

GanttStandardReport.PNG

 

 

Milestones.PNG

 

I hope this will help to solve your issue.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

VK_ Frequent Visitor
Frequent Visitor

Re: Gantt chart with reference vertical lines

Hello, @v-evelk  Thanks for your response.

But my milestones(ref's lines) are dependent on Project name and not on Tasks. Those are random dates which I have to plot on the visual. Which will come up as a straight line as shown in my post above.

v-evelk Senior Member
Senior Member

Re: Gantt chart with reference vertical lines

You are right that milestone records are considered as tasks but task records are just containers for them in this case.

In fact, you can call your milestone records as "ProjectName Milestone [1|2|3]" to show relation with a certain project.

 

MilestoneNature.PNG

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 273 members 3,031 guests
Please welcome our newest community members: