Forum Discussion
Displaying Full Data from Excel
I am having an issue where I build the filters to have the results displayed in a table. When filtering for the results I am not recieving the entirety of what is in the Excel.
ex: 8 Apples, and 2 oranges are listed in the Excel. If I am filtering for fruit, 1 apple and 1 orange will show in the table instead of 10 results.
How can I get the amount listed in the Excel to be dipslayed in the table?
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.
8 Replies
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 ExcelThis is the output
This is if I'm filering just for "orange"Anonymous this may give some context for you as well!
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.
Hi PowerBINewbie25 ,
Following up to check whether you got a chance to review the suggestion given.If it helps,consider accepting it as solution,it will be helpful for other members of the community who have similar problems as yours to solve it faster. Glad to help.
Thank you.Hi PowerBINewbie25 ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi PowerBINewbie25 ,
I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further. If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Regards,
Pallavi G.
