{"id":82,"date":"2026-02-25T09:06:48","date_gmt":"2026-02-25T09:06:48","guid":{"rendered":"https:\/\/gigz.pk\/powerbi\/?post_type=lesson&p=82"},"modified":"2026-03-16T06:53:36","modified_gmt":"2026-03-16T06:53:36","slug":"working-with-tables-matrix","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/powerbi\/lesson\/working-with-tables-matrix\/","title":{"rendered":"Working with Tables & Matrix"},"content":{"rendered":"\n

Tables and Matrix visuals in Power BI allow you to present data in a structured, tabular format. While tables are simple lists of data, matrix visuals provide pivot-table-like functionality for more advanced analysis. Both are essential for detailed reporting and summarizing information.<\/p>\n\n\n\n

Tables in Power BI<\/strong><\/h2>\n\n\n\n

Tables display data in rows and columns, similar to an Excel spreadsheet. They are ideal for showing detailed information without aggregations.<\/p>\n\n\n\n

How to Create a Table:<\/strong><\/p>\n\n\n\n

    \n
  1. In Report View<\/strong>, select the Table<\/strong> icon from the Visualizations pane.<\/li>\n\n\n\n
  2. Drag the fields you want to display from the Fields pane<\/strong> to the Values<\/strong> section.<\/li>\n\n\n\n
  3. Use the Format pane<\/strong> to adjust column width, text size, colors, and row styles.<\/li>\n<\/ol>\n\n\n\n

    Use Cases:<\/strong> Customer lists, sales transactions, or product inventories.<\/p>\n\n\n\n

    Matrix in Power BI<\/strong><\/h2>\n\n\n\n

    Matrix visuals are like pivot tables. They allow data to be grouped, summarized, and displayed across rows and columns, making it easier to analyze relationships between categories.<\/p>\n\n\n\n

    How to Create a Matrix:<\/strong><\/p>\n\n\n\n

      \n
    1. In Report View<\/strong>, select the Matrix<\/strong> icon from the Visualizations pane.<\/li>\n\n\n\n
    2. Drag a field to the Rows<\/strong> section (e.g., Product Category).<\/li>\n\n\n\n
    3. Drag another field to the Columns<\/strong> section (e.g., Month).<\/li>\n\n\n\n
    4. Drag a numeric field to Values<\/strong> (e.g., Sales Amount).<\/li>\n\n\n\n
    5. Format the matrix to show totals, subtotals, and conditional formatting for better readability.<\/li>\n<\/ol>\n\n\n\n

      Use Cases:<\/strong> Monthly sales by region, revenue by product and year, or performance comparison across teams.<\/p>\n\n\n\n

      Tips for Using Tables & Matrix<\/strong><\/h2>\n\n\n\n