Forum Discussion
Performance when User Selected Periods (SWITCH + SELECTEDVALUE)
Hi Kaycee ,
It seems difficult to improve. But you can improve performance in other ways.
1.Turn off auto date/time
2.Remove unnecessary columns
3.Optimizing the data model
4.Reducing the number of values but not the information
5.Reducing precision
6.Choosing measures over calculated columns
To learn more details ,you could read the following articles:
10 Best practice tips to improve your Tabular Model performance
HOW TO IMPROVE POWER BI PERFORMANCE - PART I
HOW TO IMPROVE POWER BI PERFORMANCE - PART II
HOW TO IMPROVE POWER BI PERFORMANCE - PART IIIWish it is helpful for you!
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Kaycee ,
It seems difficult to improve. But you can improve performance in other ways.
1.Turn off auto date/time
2.Remove unnecessary columns
3.Optimizing the data model
4.Reducing the number of values but not the information
5.Reducing precision
6.Choosing measures over calculated columns
To learn more details ,you could read the following articles:
10 Best practice tips to improve your Tabular Model performance
HOW TO IMPROVE POWER BI PERFORMANCE - PART I
HOW TO IMPROVE POWER BI PERFORMANCE - PART II
HOW TO IMPROVE POWER BI PERFORMANCE - PART III
Wish it is helpful for you!
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.