Displaying Full Data from Excel

Hi PowerBINewbie25 ,

Thanks for the follow-up! It looks like Power BI is summarizing your data instead of showing each row from your Excel file. Please follow the below steps:

If your Excel has multiple rows like 5 Apples, but Power BI only shows 1, it might grouping the data. To see each row, use a table visual, add Fruit, Name, and Quantity, and set each field to "Don’t summarize".

If you want to see totals instead, just add Fruit and Quantity, and set Quantity to Sum.This will give you the total quantity for each fruit.

Also, it’s worth checking the Filters pane on the right side of Power BI. Look at the Visual, Page, and Report level filters—there might be something applied that’s unintentionally hiding part of your data.

To help you test, Please refer the attached PBIX file and screenshot for reference:

I hope this resolve your query.If so,give us kudos and consider accepting it as solution.

Regards,
Pallavi.