Create reports that present data in the format best suited to your audience. Use table visuals to display data as flat tables, matrix visuals to analyze data across rows and columns, and embed planning sheets and PowerTable sheets to include detailed planning and operational data directly in your reports.
Tables and matrices display detailed data in rows and columns, making it easy to review, compare, and analyze individual records. Add tables and matrix visuals to display granular data alongside visualizations and KPIs.
Select Matrix from the Visualizations pane and assign row and column dimensions to create matrix tables. Matrix visuals support hierarchical dimensions in rows and columns. The toolbar includes four ribbons:
Use the Matrix ribbon to change layouts, insert charts, format numbers, apply templates, configure filter context, and select columns to display.
In the Format ribbon, you can apply a high level of customization to the matrix.
Use the Data ribbon to sort, filter, rank, define translations, and insert custom rows and columns.
Configure writeback and persist your reports to a Fabric SQL database from the Writeback ribbon.
Select the Table visual and assign row dimensions to create flat tables. Use the Table, Format, Data, and Writeback ribbons for the same operations applied in the matrix visual.
Build reports from data entered in your Planning and PowerTable sheets for integrated insights.
Planning or PowerTable sheets must be created within the same plan to use them in Intelligence sheets.
To insert a PowerTable sheet, select PowerTable from the Visualizations pane. Select the sheet to import.
To insert a planning sheet, select Planning from the Visualizations pane. Select the sheet to import. To know more about visualizing plans in real-time, see Visualize simulations, budgets, and forecasts.
Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
