Matrix table to create Gantt Chart

[irfan_abdrhman]

Hi Community,

I would like to know as I'm stuck currently where I want to create a Gantt Chart by using a normal Matrix Table in Power BI. I want to have the values to either 1, 2, or blank. I have a column "Start" and "End" and a create Table to have all the dates along with MonthYear calendar for each date. However, it's not able to turn the start and end date to a range and have "1"s or "2"s in the table of the range. it only adds 1 or 2 in the initial month only. Does anyone have an idea on how to counter this?

The Visualization : 

My Type, Start, and Finish : where each row will have Actual and Planned and each of those have their own Start and Finish :

And a complete MonthYear

Please help me in this matter, Thank you All.

Best Regards,
Irfan

[v-ssriganesh]

Hi @irfan_abdrhman,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh]

Hi @irfan_abdrhman,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @irfan_abdrhman,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @danextian & @Vijay_Chethan for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[danextian · Accepted solution]

Hi @irfan_abdrhman 

Let's hope the attached file will help you get started. Otherwise, please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind (like how 1 and 2 are calculated). You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

Please refer to this post on how to get your questions answered quickly.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447... 

[Vijay_Chethan]

how are you calculating 1 and 2 in values 
and it would be helpful if you explain what u actually mean by:
However, it's not able to turn the start and end date to a range and have "1"s or "2"s in the table of the range