Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
Thanks in advance!!!
Ale
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
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!
Thanks in advance!!!
Ale
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
57 | |
37 | |
34 |
User | Count |
---|---|
99 | |
56 | |
56 | |
46 | |
40 |