Improve Performance (Load/Opening) scorecard dashboard

Hi icassiem,

Thank you for providing the details of your scenario.

It is evident that you have dedicated significant effort to developing a comprehensive and insightful scorecard dashboard. The performance lag you are encountering, particularly with multiple visuals, filters, and data sources, is a common challenge in complex Power BI reports.

Use the Performance Analyzer in Power BI Desktop (View > Performance Analyzer) to measure how long each visual takes to render. It helps identify slow-performing visuals or DAX queries and highlights where optimization is needed. You can also export the results for further analysis, making it a useful first step in improving report performance.
Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Microsoft Learn

DAX Studio is a free external tool designed to help you analyze and improve your Power BI model. It allows you to find unused columns and measures, spot slow DAX queries, and identify memory-heavy relationships or fields with high cardinality. To get started, open your .pbix file, select External Tools > DAX Studio, and use the VertiPaq Analyzer to check table sizes, column usage, and model efficiency for more focused optimizations.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn

If each KPI card includes multiple visual options, consider using bookmark navigation to toggle between visuals without rendering them all at once. This approach improves performance by reducing simultaneous visual loading.
Data reduction techniques for Import modeling - Power BI | Microsoft Learn

Thank you and continue using Micrsoft Fabric Community Forum.