Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
aavilap
Helper I
Helper I

Table visualization overloaded (max entries reached)

Hi all! 

Hope you can help me with this, I'm having a hard time trying to get this into a funtional visual. I'm doing an analysis on retail sales opportunities based on Sales and Distribution, therefore I have identified 3 kinds of opportunities:

 

1. No distribution - stores/skus where Inventory=0 and L4Wk Sales=0

2. Out of Stock - stores/skus where Inventory=0 and L4Wk Sales>0

3. Phantom Stock - stores/skus where Inventoru>0 and LWk Sales=0

 

I have managed to create the measures to have the "count" of store/sku combinations for each of the opportunities, however when trying to show the detail on a table or matrix visual it crashes due to the amount of rows it's trying to show, I've tried reducing the rows by showing a higher level of aggrupation (instead of SKU showing category) but then the total shown in the table does not show properly. I believe there should be a way to maybe create a new summarized table for each kind of opportunity or maybe counting the rows in a different way so that when showing in a "grouped" visual the total shown is correct, but as of now I have not been able to do it in a way that works properly.

 

Below is a link to my PBIX, tables are now working because there are slicers on Category and Customer but when removing this tables crash, I'd appreciate any help on how to have a solution for this!

 

https://pbixfiles

 

Thanks in advance!!!

Ale

 

3 REPLIES 3
TomMartens
Super User
Super User

Hey,

 

I'm wondering how many GB of RAM you have available.

 

With 16GB of RAM it is possible to remove the filter from the slicers: category and customer.

 

Besides that, I removed the option "Show items with no data" from the customer field.

 

Actually, I'm wondering why there is a table visual that maybe shows 130M rows, I would try to avoid this possible outcome and start to redesign the report page - if possible.

 

No sure, but maybe this gives you an idea.

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Thanks @TomMartens I’m running on an 8GB RAM PC, the reason so many rows show is I have ~35,000 SKUs and 5,000 stores which gives me a lot of possible combinations. Since most of my final users might not be running on a 16GB RAM I need to figure out a different way to show this, do you have any suggestion on how I could achieve this? Thanks in advance!!!!
aavilap
Helper I
Helper I

Hi all! 

Hope you can help me with this, I'm having a hard time trying to get this into a funtional visual. I'm doing an analysis on retail sales opportunities based on Sales and Distribution, therefore I have identified 3 kinds of opportunities:

 

1. No distribution - stores/skus where Inventory=0 and L4Wk Sales=0

2. Out of Stock - stores/skus where Inventory=0 and L4Wk Sales>0

3. Phantom Stock - stores/skus where Inventoru>0 and LWk Sales=0

 

I have managed to create the measures to have the "count" of store/sku combinations for each of the opportunities, however when trying to show the detail on a table or matrix visual it crashes due to the amount of rows it's trying to show, I've tried reducing the rows by showing a higher level of aggrupation (instead of SKU showing category) but then the total shown in the table does not show properly. I believe there should be a way to maybe create a new summarized table for each kind of opportunity or maybe counting the rows in a different way so that when showing in a "grouped" visual the total shown is correct, but as of now I have not been able to do it in a way that works properly.

 

Below is a link to my PBIX, tables are now working because there are slicers on Category and Customer but when removing this tables crash, I'd appreciate any help on how to have a solution for this!

 

https://pbixfiles

 

Thanks in advance!!!

Ale

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.