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.
Hi PowerBINewbie25 - it would be more help if you can upload a sample of your Excel file or show how your table and filters are set up?
Here is an example. It is displaying 9 rows, but in reality it is 12 rows of fruit. They are not accounting any duplicates. The Orange is duplicated in each month but it is only showing one label per month. If I click on it then it will give me 6 oranges which is correct, but thats not the output. Please see below.
This is the original Excel
This is the output
This is if I'm filering just for "orange"
Anonymous this may give some context for you as well!