Values Between Start and End Date Gantt Chart

Hi power_bi_123456,

In my opinion, a gantt chart showing the duration of the campaigns horizontally cannot express the amount of the spending at the same time vertically, in two dimentional visual of horizontal and vertical gridlines of matrix while at the same time showing the campaign names on rows.  You maybe able to do that using the gantt chart custom visual which enables to show the names of the campaigns inside the gantt lines while at the same time, showing the amount in the vertical height and the durations using the horizontal lengths. In using the matrix table to express the duration as you required, I would write a measure like below:

Then, put that on the Values field of the Visualizations pane.  Then I used the conditional formatting on the measure value to make it blue colored.  

 I right clicked the Values field measure name, "Campaign duration" to set this conditional fomatting like below:

I am afraid that the resulting gantt chart using the matrix visual is not as professinoal looking like the custom visual one as it cannot express the names of the campaigns inside the gantt chart lines, and also, I couldn't put the gap between the gantt lines.  

Alternatively, you can try to express the campaign spending amount using the color conditional formatting instead of vertical height in the two dimentional matrix visualization.

I've tweaked the measure a bit to show the amount of "Media spend" instead of the number "1". 

Then I put the color conditional formatting.  

Similar to before, I used the right clicking of the measure name [Campaign duration] in the values field of the Visualization pane to get to the screen below for the conditional formatting.

If you would like, I can share the pbix file I prepared for this task.