Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
NilR
Post Patron
Post Patron

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 ?
NilR_0-1656049146576.png

 

 

 

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
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.



2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
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.



2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

SpartaBI
Community Champion
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.


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

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." 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors