Forum Discussion
Leave Management Dashboard
Hi anshul1123 ,
Could you please provide some sample data(exclude sensitive data) and your expected result with examples? What do you mean about creating continuous dates from the start and end date? Is there any date dimension table in your model? Please review the solution in the following similar threads and check if they can help you.
Count of employees on leave based on start and end date range
Best Regards
Rena
The below is the Dashboard build directly on the Power BI Service and not the desktop app.
The below is where i can see the data as this does not exist on the Power BI desktop. The inputs on to this data set are being brought in using Microsoft Flow (Microsoft Form going for approval and then post approval data connector to make form data streaming)
So, for example, if leave start date and end date are available, I am not sure how i could expand those dates to cover all leaves ( in the first image, the graph is only basis start dates and not all the dates in between as well.)
2nd, i dont know how to be able to impliment any changes since none of this was built using power bi desktop app but the web version only.
Hi anshul1123 ,
You can refer the following blogs to get it.
Adding a report with Power BI Desktop
Best Regards
Rena
None of these seem to be the answer to my concern.
The report is not built on Desktop app, and only exists on the web version of the service. Also, Streaming dataset is already working so the 2nd link again is irrelevant.
The concern is that:- i need to be able to expand those dates against the employees to take into account all the dates
- i need to be able to see where that data exists in order for me to be able to actually make any changes on it since this is not on the desktop app that the report was built.
Thanks.