title: Power BI Calendar visualisation
body: <p>I have a problem. I am kind of new to Power BI and I try to make a Calender Visual in Power BI, where you can see the events in a month.</p>
  <p>I have search my problem on Google but I didn't find anything. I Also tried all the visualisations in Power BI, The Calender visualisation with MAQ Software is far out the best But I can't achieve the results with my data.</p>
  <p>My data is as following</p>
  <pre><code>Project ID  Start project planning phase execution phase Monitor phase Live
  22193      18-01-2021      20-01-2021      28-01-2021    20-02-2021     03-03-2021
  29193      20-01-2021      10-02-2021      15-02-2021    19-03-2021  
  87596      25-02-2021      10-03-2021      25-03-2021   
  
   
  </code></pre>
  <p>As you can see, I have 5 phases, each with his own DateTime. So 1 Project with his Project ID can have at least 1 and maximum 5 phases.</p>
  <p>The problem is: The Calender visualisations in Power BI can only work if you have 2 dates (start and end). But as you can see I in my data, every phase has a start date of the phase.</p>
  <p>For example. Here below is The MAQ software visualisation. It is a good visualisation but it only works with 2 dates,</p>
  <p><a href="https://i.stack.imgur.com/kFhXb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kFhXb.png" alt="enter image description here" /></a></p>
  <p><em>(You can assume that the end date of a phase is the start date of the next phase
  for example, the &quot;start phase&quot; with Project ID&quot;22193&quot; starts at 18-01-2021 and ends at 20-01-2021
  And the &quot; Planning phase&quot; with Project ID&quot;22193&quot; starts on 20-01-2021 and ends on 28-01-2021 etc.)</em></p>
  <p>Somebody that can Help me with this problem?</p>
  <p>Yours faithfully</p>
  <p>EDIT: restructuring my data as follow? Will it Work?</p>
  <pre><code>Phase ID |  Project ID |  Phase |     |Start    |   | End | 
  1        |  22193      |  Start |     |18-1-2021|   |20-1-2021 
  2        |  22193      |  Planning|   |20-1-2021|   |28-1-2021 
  3        |  22193      |  Execition|  |28-1-2021|   |20-2-2021 
  4        |  22193      |  Monitor |   |20-2-2021|   |03-03-2021 
  5        |  22193      |  Live |      |         |   |03-03-2021 
  </code></pre>