search

Profitbase / PowerBI-visuals-FinancialReportingMatrix

Power BI Custom Visual for Financial Reporting
65 stars 23 forks source link

Cantidad de Columnas #546

Closed AsistenteBi closed 5 months ago

AsistenteBi commented 5 months ago

Estoy realizando un EERR que tiene columnas de ejecutado y % por centro de costo. Estoy queriendo visualizar el año completo abierto por centro de costo. Y solo me permite visualizar aproximadamente 50 columnas

image

Tengo aproximandamente 5 centro de costo por cada mes. Necesito ver todos los meses.

AndersAano commented 5 months ago

Hi @AsistenteBi,

The visual has some data limitation when it comes to the total number of rows&columns.

A way to work with this much data:

  1. Use slicers to reduce the amount of columns you see at the same time
  2. Use Field Parameters on Row/Columns to choose how many levels of hierarchy you need to see. Start with few, and increase once you want to look into a part of your matrix.
  3. Use DrillThrough on the details - Drill to Row Details, or Column detals.

Adding too much data to the visual will make it hard to work with.

-Anders