Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dashbaord is turning slower when adding multiple parameters with one mesure

Hi,

I had a requirement to do a what if analysis in my dashboard where i required multiple inputs from users to play around hence i have to create around 48 parameters i.e. 48 scroll filters on the top, solution is working fine however thje performance of dashbaord is too slow i.e. taking around a minute to load if i change any parameters.

 

Overall dashbaord loading itself is damm slower after adding this many parameters.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi Anonymous

    Do you use 48 parameters in a measure or use each parameter in each measure?

    Do any of your measures use iterator functions like SUMX, AVERAGEX?

    Additionally, you could refer to this article  which offers guidance for building fast and reliable reports in Power BI.

     

    Best Regards

    Maggie