Dynamic Filter and conditional colou

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.