Dynamic Filter and conditional colou

[tsumit07]

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.

[Anonymous]

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:

• What is the approximate size of the dataset?
• Are you using any specific visuals that are reaching their limits?
• Can you share your current DAX formulas for filtering and colouring?

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.

[tsumit07]

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

[tsumit07]