Improve Performance Report

Hi PBIRENE ,

I’d like to acknowledge the valuable input provided by the Ritaf1983  and Anonymous . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 

Slicers allow users to filter data by selecting specific values from a predefined list. They provide an interactive way to control the data displayed on visuals, such as charts and tables.

Bookmarks capture and save the current state of the report page, including visuals, slicer selections, and other interactions. They allow users to create custom views and navigate between them.

In Power BI Desktop, you can see how each report element, such as visuals and DAX formulas, performs. By using Performance Analyzer, you can view and record logs that measure the performance of each report element as a user interacts with the report element, and which aspects of its performance are the most (or least) resource intensive.

You can view the execution of slicer and bookmark separately in your report and choose a more suitable solution. For more details, please refer to the documentation: Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.