Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calendar Visualisation in Power BI

Hello all,

 

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.

 

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.

 

My data is as following

 

Project ID

Start Phase

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

 

 

87549

02-03-2021

05-03-2021

06-03-2021

12-03-2021

 

 

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. 

 

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.

 

For example. Here below is The MAQ software visualisation. It is a good visualisation but it only works with 2 dates,

 
 
 

 

 

(You can assume that the end date of a phase is the start date of the next phase

for example, the "start phase" with Project ID"22193" starts at 18-01-2021 and ends at 20-01-2021

And the " Planning phase" with Project ID"22193" starts on 20-01-2021 and ends on 28-01-2021 etc.)

 

Somebody that can Help me with this problem?

 

Yours faithfully

3 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support

    Hi Anonymous ,

     

    You need to use a custom visual, try to find it in Business Apps – Microsoft AppSource.

    If there's no such a custom visual, you need to create it by yourself.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.