Summing Area and creating a stacked bar chart based on category during a data range.

[HopeThomas456]

Hi! I have been working on creating a deterministic forecast for a case study and running into some issues. I have data with each item having area, program, shop, Category, start and end date. I want to create a stacked bar chart in Power BI that sums that area that is present during that month and has a legend of category. Is there a way to do this in power query or power BI. Below is the data I am trying to represent. The program and shop would be filters I can select that will change the graph output 

[HopeThomas456]

Thank you @amitchandak for the advice! I have watch the content and a bit confused on how I would get the categories in a stacked bar chart. Do you have a demonstration with data similiar to mine above? I would also need a slicer for the program and shop. Thanks! 

[amitchandak]

@HopeThomas456 , Refer

Between Dates - Dates between
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

Measure way

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU