Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
5 years ago

Performance issues - Stepped layout off

Hi Power BI Experts,

 

I have oberved a huge performance issues while i turn off the stepped layout off in my matrix chart. While I am changing the filters from one filter to other, i am facing this perfomance issues. Please advice and let me know why i am seeing huge performance issues while changing this option?

 

Stepped Layout on - 2 Sec

Stepped Layout off - 20 Sec

 

 

Need Help

3 Replies

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    Hi, prakash11440278 

     

    I'd like to suggest you use Performance Analyzer to examine report element performance.

    Each visual's log information includes the time spent (duration) to complete the following categories of tasks:

    • DAX query - if a DAX query was required, this is the time between the visual sending the query, and for Analysis Services to return the results.
    • Visual display - time required for the visual to draw on the screen, including time required to retrieve any web images or geocoding.
    • Other - time required by the visual for preparing queries, waiting for other visuals to complete, or performing other background processing.

     

    Best Regards

    Allan

     

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

    • prakash11440278's avatar
      prakash11440278
      Post Prodigy
      5 years ago

      HI v-alq-msft ,

       

      I have already tried this one and observed only matrix chart is taking time to refresh the data. I have collected the DAX query for that. Can you please suggest how i need to analyse further on this?