Reply
KPro17
Frequent Visitor
Partially syndicated - Outbound

Card pulling wrong data

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. 

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Syndicated - Outbound

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
Frequent Visitor

Syndicated - Outbound

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?

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)