https://store-images.s-microsoft.com/image/apps.6217.07ddfefa-4995-4ba8-8b4b-cbf70538563a.abecd647-355f-4d35-a168-d9c9fb63b4df.8e82413f-ee25-4538-b5d4-7ba40c901bcc

Matrix Planner

by Ilustratown

(2 ratings)
Download SampleInstructions

Facilitates planning and forecasting through writeback functionality within Power BI

Matrix Planner is a Power BI visual designed to empower users with a streamlined approach to planning, forecasting, budgeting, and financial reporting directly within Power BI. The visual enables the seamless integration of operational reporting and financial planning within the same tool, maximizing the potential of Power BI data models. With this Power BI visual, you can effortlessly writeback your data and process your semantic models or analysis services cubes directly within Power BI. As changes are made to the database, the visual will refresh automatically ensuring a unified and optimal experience for financial planning and operational reporting.

Features:

  • Writeback capability
  • Distributes values ​​to descendants using one of three operations (Replace/Uniform/Relative)
  • Aggregate calculations (Sum/Average)
  • Expand/Collapse Rows
  • Write-Security measure
  • Read-only measures
  • Show/Hide columns and rows subtotals
  • Switch measures to rows

Benefits:

  • Ability to change data in SQL tables through Power BI
  • Use Direct Query or Import Mode
  • Process semantic models or analysis services cubes
  • Build, optimize and monitor business process planning


Matrix Planner is available for download on Power BI through Microsoft AppSource. To enable the visual you will need a license that can be purchased on Microsoft AppSource.

For additional information about the visual, please visit Matrix Planner web site.

Visual capabilities

When this visual is used, it
  • Can access external services or resources

At a glance

https://store-images.s-microsoft.com/image/apps.32659.07ddfefa-4995-4ba8-8b4b-cbf70538563a.1a4838b0-bbe5-42ce-aa39-f92bee40ef6f.b2775478-6c82-4800-96c2-ca35aa3f6ff3
/staticstorage/b883092/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.32659.07ddfefa-4995-4ba8-8b4b-cbf70538563a.1a4838b0-bbe5-42ce-aa39-f92bee40ef6f.b2775478-6c82-4800-96c2-ca35aa3f6ff3
https://store-images.s-microsoft.com/image/apps.20058.07ddfefa-4995-4ba8-8b4b-cbf70538563a.1a4838b0-bbe5-42ce-aa39-f92bee40ef6f.8b3af1cb-f712-4980-9f8d-7a9fa64b460b
https://store-images.s-microsoft.com/image/apps.32125.07ddfefa-4995-4ba8-8b4b-cbf70538563a.1a4838b0-bbe5-42ce-aa39-f92bee40ef6f.07a9c057-4ec1-4537-b204-ff66f6fc678f
https://store-images.s-microsoft.com/image/apps.55328.07ddfefa-4995-4ba8-8b4b-cbf70538563a.1a4838b0-bbe5-42ce-aa39-f92bee40ef6f.8fe1200e-703c-4f32-b891-fd4419253085
https://store-images.s-microsoft.com/image/apps.17244.07ddfefa-4995-4ba8-8b4b-cbf70538563a.1a4838b0-bbe5-42ce-aa39-f92bee40ef6f.6c692cd2-e716-405c-b9f9-b2625164548c