Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.