Creating table and matrix visuals
Table and matrix visuals are when 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 for URLs and email as well as clustering are included in the There's more... section.
How to do it...
Table visual exceptions
In this example, a report...
