Table and matrix visuals are appropriate when visibility to precise, individual measures is needed or when data is viewed at a detailed level, such as individual transactions. Table visuals in Power BI conform to the classic "list" report format of columns and rows but support powerful cross-highlighting and formatting options, including conditional formatting. Matrix visuals include table visual features and correspond to the layout and general functionality of pivot tables in Excel: two-dimensional representations of measures with the ability to drill up and down the row and column axes.
In this recipe, a table visual is used to identify exceptions based on conditional formatting rules. Additionally, an example matrix visual is created to support interactive drill down and cross-highlighting. Brief examples of table visuals support...