Microsoft Power BI Quick Start Guide

The Matrix visual

Where a table does a great job of allowing users to consume tons of detailed data about a single category, the Matrix visual can accomplish this for more than one category. The Matrix visual allows users to not only select a category for the rows, but means we can also select a field to populate the columns as well, which allows us to see detailed data at a cross sections for two categories. Conditional formatting is also available for use within the Matrix visual, and is incorporated in the same fashion as we accomplished in the previous example. Other than Conditional Formatting, the Matrix visual can take advantage of established hierarchies to give users that capability of drilling down into more granular data. Many ...