Calendar Visualisation in Power BI

[Anonymous]

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

[v-lionel-msft]

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.

[Anonymous]

Hi @v-lionel-msft ,

Thank you for your replay, I have tried the custom visuals in the market but unfortunatelly there is no visual that fits with my requirements. And I am a bit new so I don't know how to make a custum visual.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Create Visual/Custom Visual for Power BI: Different Approaches - RADACAD

Please refer to the blog, which mentions various ways to create custom visuals.

But visuals created with R/Python have certain limitations, please refer to this document.

Known limitations(Python visual) 

Known limitations(R visual) 

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.