Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost 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 thi...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity 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
    Icon for Post Prodigy rankPost 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?