Data Shaping Help?

thanks amitchandak  but there's issues with that, probably based upon my lack of description.  The calendar table is already dynamically created (see MyCal in post).

To visualise it better, the root data set (DefectData) looks like this:

The calendar table (MyCal) is generated off two querries, as described earlier:

Back to (DefectData), pivoting off the (Plant) column will change the data to either of these two tables:

Or

For sanity sake, i create and save them both as (DefectStartTable) and (DefectEndTable).

The desired end is to construct the following:

From there, the visualisation aspects are fine.  It more a matter of how do I transform the data natively within PowerBI without resorting to pre-transforming it in the original source.  The real trick is how do I create a positive response for dates between a defect (ie. 29-10-2017), other wise the visualisation won't know to join the start/end dates. 

I initially tried the root data (DefectData) as a gantt visual but the successive defects cascaded down the visual as seperate instances and not reoccurring instaces against the (Plant).

Hope that this better explains the dilema.