Troubleshooting visuals that take too long to load?

[Anonymous]

I have a .pbix, and I have a visual that has a matrix with over 10 measures, sometimes it takes 5 minutes to load and sometimes it never loads.

Is there a way to exactly pinpoint which measure is causing the visual not to load?

[amitchandak]

@Anonymous , check with performance analyzer which is taking time

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

if you have a measure that uses related or relatedtable , or any calculation that can be pushed to column instead  of measure do that

example

Sumx(Sales, [sales]* related(price[price]) )

Create a new column and then sum it up

T sales  = [sales]* related(price[price])