Forum Discussion
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.
I'm not understanding this solution.
- If there are 5 apples and 3 oranges, it should list out 8 items. Instead it will list one apple and one orange and when I click on the apples, it will display in the other table that I use as a count. (I copy/pasted the main table and switched to a card and count, to see what is displaying in the table. This is how I realized that the table is showing one name per selection instead of the amount of names listed in the Excel)
- What do you mean review the filters pane? I believe I might have, but I'm not sure.
Is there a visual or step-by-step I can see?
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.