Forum Discussion
Card in PowerbI not pulling the correct Data from Excel from SharePoint
Good Day, I have 4 excel documents that are saved in SharePoint. In each excel document it has a tab called Availability that allows the user to enter if they took a business, sick or vacation day d...
Hi Pete,
Please see the attached documents. All four documents have the same availability and leave types tabs which was pulled from SharePoint into PowerBI. The Leave Types have the place holders for determining the business leave for each month (Bjan), the balance sick leave for each month (SJan) and balance vacation leave (VJan). Once a user takes a specific leave during the course of the month, it will add the total respective leaves and take it away from the leave types tab holders and show the new balance Business (AO) Sick (AP) and Vacation (AQ).
In powerbi, I would like to card to show the balance leave type represented in AO, AP, and AQ.