Card pulling wrong data

[KPro17]

Good Day,

I have multiple excel documents in SharePoint and each excel workbook has a tab called Availability. I pulled each availability sheet into powerbi and i want to display the balance leave for vacation, sick and business. 

When i created a card to represent the balance leave, say the balance leave for vacation is 40..it is say 534K ...i tried to change the sum to count or dont summarize and it still is displaying the high number. 

Any feedback would be appreciated. 

[v-luwang-msft]

Hi @KPro17 ,

If you put the xlsx in a local folder and then use Desktop to import the data, does it also pull the data incorrectly?

If so，Could you pls share your xlsx ?And remember to remove confidential data.

Best Regards

Lucien

[KPro17]

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 during the a specific month. At the end of the each month it has 3 additional columns named Business, Sick and Vacation which deducts the total amount of days taken each (business, sick and vacation) and it shows the employee's balance days remaining for the year.

I created a card in Powerbi to show the balance days for each but it is pull a high figure (e.g. if the balance vacation days for user X is 40 it is pulling 536)

Is there a way just to pull the correct number from the columns suggested?