Forum Discussion
Leave Dashboard for Custom Sprint dates from Excel data
Hi I want to create a dashboard with Bar chart showing the number of leaves taken by each employee sprint wise. I have a sprint table in PowerBI with Sprint ID, Start Date, End Date Like below
Employee Leave data is captured in excel in the following format for each month one Sheet (Sheet is named with Short form of Month name with first 3 letters) and every calendar year new excel workbook
I need to map the leave data to the sprint periods and calculate the number of leaves taken by each employee per sprint in Bar chart.
Request to help me to acheive this.
Thanks
Srinivas
1 Reply
Hi srinivasjr04
Please provide a workable sample data (not an image), your expected result from the same sample data and the reasoning behind. Also, what are those numbers in the first row of your second screenshot? Please refer to this post on how to get question answered quickly. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
