Hi, I have a SPC chart as shown in screenshot below but when I select slicer, it takes longer than usual (around 10 mins) to load the chart. How to modify the measures to make it load faster? Sample here.
Hi @PBI_newuser
Here are some sugesstions about how to optimize DAX.
And in your case, i create a new table instead of the values() in Rolling Average 3 months.
Divide() instead of /
and you can use performance analyzer to see how much time DAX took.( View ->Show pane->performance analyzer)
Finally , the vsiual laod faster the used , but you can try to optimize [Average], I don’t quite understand your calculation logic.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PBI_newuser
Here are some sugesstions about how to optimize DAX.
And in your case, i create a new table instead of the values() in Rolling Average 3 months.
Divide() instead of /
and you can use performance analyzer to see how much time DAX took.( View ->Show pane->performance analyzer)
Finally , the vsiual laod faster the used , but you can try to optimize [Average], I don’t quite understand your calculation logic.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
