Change Mgmt - Calender view (GroupBy Changes by Start Date)

[Anonymous]

My manager has asked me to create a GroupBy Column of Changes by Start Date and make it visible in a calender view so the output expected is just like a calender view in which This week or This Month or Last Month these are the changes (CHG111, CHG123, that are going to start. To give a better example the view would look like a calender and I can see that this week on 13th May 2021 in calender it shows CHG567, CHG789 visible and so on and so forth. Can you please help me. Below is the table I am working on. Can you help?

The Calender view where the change numbers must be visible

[V-pazhen-msft]

@Anonymous 

Not very clear to me, can you share an sample table and expected output based on the table, seems you expecting a grouped date column but I am not sure how the started are grouped. However, I am pretty sure even with expected column, it is not supported in Power BI to have data displayed in a calendar visual.

Paul Zheng _ Community Support Team

[amitchandak]

@Anonymous ,

What is expected output is not very clear to me

You have a custom calendar visual

https://appsource.microsoft.com/en/product/power-bi-visuals/WA104380905?tab=Overview

Or you can use matrix visual also

Week number on row and weekday column. Will allow creating this type of view

[Anonymous]

Thanks Amit for your reply. Im aware of the calender visual which I have already added in the visualization panel.

The expected output is I want to see all change numbers grouped by start date in a calender view.

Consider the above screeenshot of the calender and in that daywise the change numbers or IDs would be visible according to the filter selected. Just like we a have Microsoft teams calender with meetings listed on different days, months. I hope it make sense now?