Skip to main content

Reporting - Add a matrix visualisation to a report

Matt Troy
Updated
ℹ️ Info: This article refers to Reporting and Analytics with Power BI. View the FAQ for more details.

In this article, we’ll show how to add a matrix visualisation to a page in Power BI.

Matrix visualisations are a great way to summarise information in lengthy data tables.  Where a table supports two dimensions and the data is flat (meaning duplicate values are displayed and not aggregated), a matrix automatically aggregates the data. Rows can be expanded and collapsed to show and hide data layered beneath, allowing the viewer to focus in on detail as required.

Watch the video below or follow the steps below to add a matrix visualisation to a report:

Steps to add a matrix visualisation to a report

  1. Start a new User-created report or open an existing report
  2. From the Visualisations panel, select 'Matrix visualisation':REPORTING_SelectAMatrixVisualisation.pngAn empty matrix visualisation - which looks a lot like a data table at this point - will be added to the report.
  3. Check that the matrix visualisation is still the selected item on the page. To populate the matrix visualisation, drag fields from the Data panel into the 'Row' Column' and 'Value' area in the Visualisation panel:REPORTING_Populate_Matrix.png Fields will populate in the matrix as they are added to the 'Row' Column' and 'Value'
  4. Save the report when you're done

Discover more about User-created reports

For a hands-on learning experience, explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs. 

If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI. You'll begin with Power BI’s top five features, then dive deeper into each one with step-by-step guidance.

Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, packed with 100+ common questions and in-depth resources. You can also join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.

Related articles