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 ,
Thank you for reaching out to us on Microsoft Fabric Community Forum!
If your Power BI table is not displaying the full quantities from your Excel file when applying filters, it might be due to how the data is structured or how the filters are applied.
- First, check if your Excel file contains multiple rows for the same fruit (e.g., 5 Apples and 3 Apples in separate rows). In Power BI, make sure you are using a table visual with the 'Fruit' and the 'Quantity' fields in Values, set to summarize using "Sum" and not "Count."
- Next, review the Filters pane for any visual-, page-, or report-level filters that might be restricting the data shown.
- Also, inspect any slicers on the report,if a slicer is selecting only one row of "Apple" instead of all, you will see partial results. If your data model involves multiple tables, ensure relationships are correctly defined and not unintentionally filtering your results.
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.