Forum Discussion

D0minique's avatar
D0minique
Frequent Visitor
5 years ago

Slow switch measure

Hello,   I was wondering if somebody has found a working solution for the slow switch statement problem? For my dashboard I would like to switch between over 100 measures (I call this the base m...
Need Help
MFelix's avatar
MFelix
Super User
5 years ago

Hi D0minique ,

 

Taking into account that you have a large dataset and depending on the calculations you want maybe is good in terms of performance to check the aggregations:

 

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations

 

This can reduce table sizes so you can focus on important data and improve query performance. Aggregations enable interactive analysis over big data in ways that aren't possible otherwise, and can dramatically reduce the cost of unlocking large datasets for decision making

D0minique's avatar
D0minique
Frequent Visitor
5 years ago

Thank you, MFelix.  A good option to consider. StefanoGrimaldi mentioned this as well. However, we do have many dimensions as well, so the aggregated tables will still be large, unless I minimize the dimensions to filter on, which would be a large setback...

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi D0minique ,

     

    There're 10 mehtods to speed up your report. I don't know if it can help you a bit.

    1. Only keep necessary visuals
    2. Use integers instead of text values whenever possible
    3. Stick to Power BI’s default visuals
    4. Avoid both-directional relationships in your data model
    5. Understand the difference between duplicate and reference queries
    6. Only load data which will be reported upon
    7. Slicers can be real performance killers
    8. Overthink your data modeling technique
    9. Split granularity to lower cardinality
    10. Measure performance: Get a clear view on how a report is currently performing so you can quantitively measure and compare the outcome of any of your taken actions. Power BI has a built-in feature, called the performance analyzer, enabling users to measure how much time is spent on rendering visuals and how much time is spent on executing DAX code. It even gives you the full extract of the DAX code, which you can further analyze in tools as DAX Studio.

     

    About performance analyzer, you can refer to Use Performance Analyzer to examine report element performance.

     

    And there're other Top 5 Power BI Performance Analyzer tools.

     

    Also there's an official document you can refer to

    Optimization guide for Power BI

     

    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.

  • D0minique's avatar
    D0minique
    Frequent Visitor
    5 years ago

    Hi Anonymous, thank you for this nice overview!