Forum Discussion

NilR's avatar
NilR
Post Patron
4 years ago
Solved

Prioritizing Measures/Visuals

Below dashboard has 15 matrix and each has about 5 to 10 measures. I have to have them all in one page but page takes about 1 to 2 min to load after changing the slicer. I am wondering if there is any option to prioritize measures or visuals to tell which one to load first? is it doable ?

 

 

 

  • Hi NilR,

    You can create a dashboard with pinned tiles from your report. See here.
    The rendering mechanism of tiles is different and you may get better results.

    If you are using Power BI Premium (like a PPU license), you can also use caching to improve the page's initial load. See here.

    You can also try to reduce the number of visuals on the page by using the small multiples feature (see here).
    Using fewer visuals to present the same content is one of the best ways to improve performance.



    Showcase Report – Contoso By SpartaBI


          

3 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion

    Hi NilR,

    You can create a dashboard with pinned tiles from your report. See here.
    The rendering mechanism of tiles is different and you may get better results.

    If you are using Power BI Premium (like a PPU license), you can also use caching to improve the page's initial load. See here.

    You can also try to reduce the number of visuals on the page by using the small multiples feature (see here).
    Using fewer visuals to present the same content is one of the best ways to improve performance.



    Showcase Report – Contoso By SpartaBI


          

  • SpartaBI's avatar
    SpartaBI
    Community Champion

    NilR there is no official or documented way to control the order of which visual render first. Usually it's from left -> right -> bottom but this is not guarantee. 
    Usually you don't put so many visuals at once in a pape. Should be no more then 4/5. 
    You should consider either split to different pages / use bookmarks to switch between them if you want to keep one page / maybe put them on a dashboard.
    On top of all of that, of course put focus on improving your model and measures to gain maximum performance.
    Hope that helps.





          

    Showcase Report – Contoso By SpartaBI

    • NilR's avatar
      NilR
      Post Patron

      Thank you very much!!!

      what do you mean when you said "/ maybe put them on a dashboard." in your last statement you said "You should consider either split to different pages / use bookmarks to switch between them if you want to keep one page / maybe put them on a dashboard."