Gant Chart Project road map

DAX DAX Calculations
1

I have data with a Project title for different projects, a Start date, and an end date. I want to make a gant chart with start and end date in the x-axis and project title as the y-axis to show the project timeline? any prior post or solution to give me an idea.

2

@jojo,

@sam.mckay did a detailed video on this topic that I think you’ll find very helpful:

  • Brian
3

@BrianJ this is good but in my case, having 365 days and a lot of projects, using the matrix as a Gant chart will be complicated because I have to make 365 columns in the matrix(power bi will complain) and then manually drag them to look like a stacked bar chart. I am thinking about if I create a measure of different date ranges and use them as a legend in a stacked chart, I m not sure if that works.

4

@jojo,

If your organization allows it, you may want to look into custom visuals for this. There are a bunch of Gantt custom visuals available, including ones by xViz, Acterys and MAQ, all of whom I think typically make quality visuals.

  • Brian
1 Like