How to improve the report performance

[Anonymous]

I have a report where i am using around 50 measures everything needs to be calculated in runtime based on the date value i select. The report takes lot of time to refresh whenever i change the date filter. When i check the query analyzer it takes lot of time in the other option which means waiting for other visuals to load,

Please suggest how to improve the report performance. All the values i am displaying are dynamic values based on the date slicer so i cant move as calculated columns.
Thanks in advance

[Anonymous]

Thank you kunal. It is a 2 page report. i have made few changes in the visual location and performance for little bit ok when compare to before. But still i have the following section in report where i need to select a date and the corresponding data will display for various periods it takes lot of time and business wont wait that much time to see the results. any suggestions for this.

thanks,

Kayal Sundaram

[kunal15sep]

1. Remove unwanted columns in the data model.
2. Avoid nested functions,e.g. IF, CALCULATE, etc. used in calculations.
3. Too many visuals on a page will render poor performance even is using bookmarks.
4. Data granularity reduction by aggregating to a level higher like reporting in months instead of days.
5. Replace caculated columns with measures.