Hi All,
I am very new to power BI. I have the follwoing data in my table
StartDate endDate FirtsName LastName Section ProjectName TotalHours
12-06-2018 12-19-2018 M1 ML1 Developer Project1 14
11-22-2018 12-5-2018 M2 ML2 QA QAProject 20
12-06-2018 12-19-2018 M1 ML1 Developer Project3 10
I want to show a bar chart and pie chart in my power bi desktop that shows the hours spend by each developer on each project. Also, is it possible for the user to filter the chart based on startDate, endDate and/or project Name
I am connectimng to the sql server and passing the below query to power BI desktop to get the above data:
select pp.StartDate, pp.EndDate
,rs.FirstName, rs.LastName, rs.Section
,pd.Name
,tsd.Hours1+ tsd.Hours2 + tsd.Hours3 + tsd.Hours4 + tsd.Hours5 + tsd.Hours6 + tsd.Hours7 + tsd.Hours8+ tsd.Hours9 + tsd.Hours10 + tsd.Hours11 + tsd.Hours12 + tsd.Hours13 + tsd.Hours14 as TotalHours
from [dbo].[TimeSheet] ts
Inner join [dbo].[TimeSheetHours] tsd on ts.Id= tsd.TimeSheetId
inner join [dbo].[PayPeriod] pp ON ts.PayPeriodId = pp.Id
inner join [dbo].[Resource] rs ON ts.ResourceId = rs.Id
inner join [dbo].[ProjectDetail] pd ON tsd.ProjectId = pd.Id
order by pp.StartDate desc
any help or any tutorial related to the topic will be highly appreciated.
