Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello Everyone,
I am working on a huge dataset.
Requirement is to find Parent and including all its components on basis of one of the components and than colour BOM parent altervativly.
I have used the approach grouping items and creating in new table with union with component column.
for colour i have used randx and calculating MOD.
But my data exceeds its visual when i searrch from one of the component.
Could you please help and support me on this topic?
Thank you all in advance.
Hi @tsumit07 ,
Based on the information you provided, it is common to exceed visual limitations in large datasets, especially when filtering or searching. You can consider the following strategies when encountering this problem:
1. Aggregate the data prior to visualisation to reduce the number of rows displayed.
2. Implement paging or delayed loading to load data in chunks.
3. Optimise search/filter queries to improve performance.
4. Use samples of the dataset for initial exploration and visualisation.
5. explore hierarchical visualisations (e.g., tree diagrams, sunburst diagrams) to display parent-child relationships more effectively.
You can read this article to see guidelines for working with large datasets:
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
If the above suggestions do not help, can you provide more details below to further assist you:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Ada,
Thank you so much for the suggestion.
I have already aggregated data from multple tables to one and grouped it together. I am visalising data inside table.
Data size is 3M rows with 17 columns and it will exceed it in time.
For filtering, i am using grouped column function from PBI editor and created new separate table with (Columns: Index, BOM Parent, Compoents) from existing table.From newTable i am filtering data from Component column.
Visual exceed as soon as i use Randx/Index and MOD function for Background coloring. (Is there any suggestion i could try for colouring).
Unfortunately, i can not share PBI file for data privacy reasons.
Is there any other approcah should i be taking from here on?
Thank you so muhc for support.
Regards
S
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |