Ayuda con flowsheet para optimizacion del rendimiento de dashboard

[César_SF]

Hola Comunidad

Tengo la mision de optimizar un dashboard y me encuentro que hay dos arboles creados con tarjetas, como mostrare en la imagen

Se demora mucho en cargar y estoy en a mision de optimizar el reporte, alguna sugerencia de visual o metodo para poder cambiar o mejorar esto?

Saludos!

[Shahid12523 · Accepted solution]

Too many card visuals = slow load (each one is a separate query).

Solution: Replace with a matrix/KPI visual or a Decomposition Tree instead of many cards.

Optimize DAX: Use base measures + VAR, avoid repeated heavy filters.

Check Performance Analyzer to find the slow visuals.

Pre-calc data in Power Query, aggregations, or dataflows to reduce load.

Best quick win: combine the cards into one matrix or decomposition tree visual.

[César_SF]

Gracias estimados @v-dineshya @Shahid12523 , servirá también crear una measure router para poder juntar varias measure y así conglomerar todas posteriormente en una sola matriz?

lo hice una vez pero al tener muchas medidas en la medida router igual se demoraba un poco... pero no tanto como la que les muestro.
Igual hay otra pestaña en este dashboard que tiene más de 30 tarjetas y está horriblemente lenta.

En fin, estoy atancado las queries y tablas analizándolas con power bi helper o dax studio y posteriormente atacando las visuales.

[v-dineshya · Accepted solution]

Hi @César_SF ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @Shahid12523 , Thank you for your prompt response.

Hi @César_SF , In addition to @Shahid12523  response i am adding some more points.

Please try below visuals and optimization suggestions to improve dashboard performance:

1. Please try to Simplify the Tree, Combine similar metrics or categories into collapsible groups. Avoid deep nesting unless absolutely necessary. Show high-level metrics and allow drill-down only when needed.

2. Load only visible parts of the tree initially. Expand nodes dynamically when you interacts with them.

3. Please replace the tree with Treemaps and Sunburst custom visuals.

4. Use aggregated data instead of raw data. Cache frequently accessed data. Preprocess the data outside the dashboard, In Power Query or any ETL tool. Use Query folding in Power Query.

5. Use virtual scrolling for long lists. Minimize use of SVG, consider Canvas or WebGL for better performance. Reduce animations and transitions.

6. Add  indicators for sections. Use filters to reduce visible data. Use tooltips instead of showing all data upfront.

Please refer below links.

Treemaps in Power BI - Power BI | Microsoft Learn

Sunburst

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[Shahid12523 · Accepted solution]

Too many card visuals = slow load (each one is a separate query).

Solution: Replace with a matrix/KPI visual or a Decomposition Tree instead of many cards.

Optimize DAX: Use base measures + VAR, avoid repeated heavy filters.

Check Performance Analyzer to find the slow visuals.

Pre-calc data in Power Query, aggregations, or dataflows to reduce load.

Best quick win: combine the cards into one matrix or decomposition tree visual.