Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Format Power BI Matrix

by suresh

How to Format Power BI Matrix report with an example?. The Power BI Formatting Matrix includes changing the Matrix Grid Colors, Row formatting, Column formatting, row and column colors, Matrix Title text, and background color, etc.

To demonstrate these Power BI matrix formatting options, we are going to use the Matrix that we created earlier. Please refer to Create a Matrix in Power BI article to understand the steps involved in creating a Power BI Matrix.

How to Format Power BI Matrix

Please click on the Format button to see the list of Matrix formatting options that are available in Power BI.

Format Power BI Matrix 1

Format Power BI Matrix General Settings

Use this General Section to Change the X, Y position, Width and height of a Matrix

Format Power BI Matrix 2

Format Power BI Matrix Style

From the below screenshot, you can see the list of styles that are available to style this Matrix. Please select any style as per your requirement.

Format Power BI Matrix 3

For now, we are selecting the Alternating Rows option from the drop-down list. It adds alternative row colors and adds Black color to Header, Subtotals, and Grand totals.

Format Power BI Matrix 4

The following are the list of options that are available for you to format the Power BI Matrix Grid.

  • Vert Grid: Toggling this property from Off to On add Vertical Grid to the Matrix. Nothing but enabling Vertical line to separate each column.
  • Horiz Grid: Add Horizontal Grid. Nothing but enabling Horizontal line to separate each row.
  • Horiz Grid Color: Changing the Color of a Matrix Horizontal Grid.
  • Horiz Grid thickness: Matrix Horizontal Grid Line width
  • Row Padding: Space between the rows.
Format Power BI Matrix 5

As you can see from the below screenshot, w changed the grid color to gold, grid thickness to 2, and row padding to 10

  • Outline Color: Color after the Header, and row group. We are using the default green as the Outline color.
  • Outline Weight: Matrix Line width. We changed the line stroke to 4
  • Text Size: Font size of table values. Let me change the text size to 9
Format Power BI Matrix 6

As you can see from the below screenshot, we enabled the Vertical Grid and assigned some random colors.

  • Vert Grid Color: Change the Color of a Matrix Vertical Grid.
  • Vert Grid thickness: Matrix Vertical Grid Line width or stroke
Format Power BI Matrix 7

To adjust the space, we renamed the column names under the values section. As you can see, we changed the Sales Amount names as Sales and Total Product Cost as Cost

Format Power BI Matrix 8

Format Column Headers of a Matrix in Power BI

This section is to alter the Header Colors. As you can see from the screenshot below, we changed the Font color to White, Background color to green. Next, Font Family to Cambria, Outline to Top + Bottom (Outline added to the top and bottom of a Header), Text Size to 15, and Header text alignment to center.

Format Power BI Matrix 9

Format Row Headers of a Matrix in Power BI

This section is used to alter or format the Row Headers section. Here, we changed the Font color to White, Background color to Red, Outline to Top + Bottom (Outline added to the top and bottom of each row), Font Family to Cambria, Text Size to 15, and text alignment to center.

Format Power BI Matrix 10

As you can see from the above screenshot, though, we changed the Background color of total rows (Row Headers), only Total background color has changed. It is because of the Banded Row Style property that we explain in the next step

Format Values of a Matrix in Power BI

You can use this section to change the Matrix values. As you can see from the screenshot below, we changed the Font colors and Back color of the even and odd rows.

Format Power BI Matrix 11

Banded Row Style: By default, it set to On. It means the Row Header color will be the same as the remaining Row fields.

Let me set this Off. It changes the Row Header Background Color to the Purple. It is because, we applied this color in the above step, i.e., Row Headers section

Format Power BI Matrix 12

Show On Rows: Enabling this option show the totals on Rows

Format Power BI Matrix 13

As you can see, we removed the Outline and Changed the Font to Cambria, and Text size to 13

Format Power BI Matrix 14

Format Subtotals of a Matrix in Power BI

Use this subtotal section to alter the text and background color of subtotals. By toggling Row subtotals, column subtotals to Off, you can remove the Totals completely.

Format Power BI Matrix 15

Format Grand Total of a Matrix in Power BI

Use this Grand Total section to alter the text and background color of Total. As you can see from the below screenshot, we changed the Totals Font color to white, Background color to purple, Font Family to Cambria, and Text Size to 14.

Format Power BI Matrix 16

Apply to labels: By toggling this option to On apply the Background Color to the Header of the Total. As you can see, Power Bi has changed the background color of the text of a header of Total

Format Power BI Matrix 17

Format Power BI Matrix – Field Formatting

Use this section to format individual columns in a Matrix.

Format Power BI Matrix 18

For example, you can use this section to assign a completely different color to one column. Here, we are selecting Sales.

Format Power BI Matrix 19

For the Format Power BI Matrix demo purpose, we changed the background color to Pink for this column only.

Format Power BI Matrix 20

Format Power BI Matrix – Conditional Formatting

Use this section to format Metric columns (Numeric) in a Matrix. For example, adding a background color to a complete column, or adding data bars, etc. We will write a separate article to explain these settings

Format Power BI Matrix 21

Format Power BI Matrix Title

By toggling the Matrix option from Off to On, you can enable the Matrix title.

From the screenshot below, you can see we added the Title Text as Sales Vs. Total Product Cost by Product Color and Occupation. Next, we changed the Font Color to Green, Font Family to Georgia, Text Size to 25, and Title Alignment to center. If you want, you can add the background Color to the Matrix title as well.

Format Power BI Matrix 22

Format Power BI Matrix Background Color, and Borders

You can add a Background color to a Matrix by toggling Background option to On. For the Format Matrix demonstration purpose, we added sky pale yellow color with 34% transparency.

Similarly, by toggling Border option from Off to On, you can add Borders to a Matrix.

Format Power BI Matrix 23

Placed Under: Power BI

  • Install Power BI Desktop
  • Connect Power BI to SQL Server
  • Add Rename and Duplicate Pages
  • Connect to Multiple Excel Sheets
  • Get Excel Data to Power BI
  • Get Text File Data to Power BI
  • Load Data from Multiple Sources
  • Remove Power BI Table Columns
  • Create Power BI Bins
  • Power BI Joins
  • Change Column Data Types
  • Combine Multiple Tables
  • Power BI Clusters
  • How to Enter Data into Power BI
  • How to Format Dates in Power BI
  • Create Power BI Groups
  • Create Power BI Query Groups
  • Create Power BI Hierarchy
  • Power BI Pivot Table
  • Power BI Unpivot Table
  • Rename Power BI Table Names
  • Rename power bi column names
  • Split Columns in Power BI
  • Remove reorder power bi column
  • Power BI Area Chart
  • Format Power BI Area Chart
  • Power BI Bar Chart
  • Format Power BI Bar Chart
  • Power BI Clustered Bar Chart
  • Clustered Column Chart
  • Create a Power BI Card
  • Format Power BI Card
  • Create Power BI Multi-Row Card
  • Format Power BI Multi-Row Card
  • Power BI Column Chart
  • Format Power BI Column Chart
  • Power BI Donut Chart
  • Format Power BI Donut Chart
  • Power BI Funnel Chart
  • Format Power BI Funnel Chart
  • Power BI Heat Map
  • Power BI Line Chart
  • Format Power BI Line Chart
  • Line & Clustered Column Chart
  • Format Line & Clustered Column
  • Line & Stacked Column Chart
  • Format Line & Stacked Column
  • Power BI Matrix
  • Format Power BI Matrix
  • Power BI Table
  • Format Power BI Table
  • Add Data Bars to Power BI Table
  • Add alternate Table Row Colors
  • Power BI Pie Chart
  • Format Power BI Pie Chart
  • Power BI Ribbon Chart
  • Format Power BI Ribbon Chart
  • Power BI Treemap
  • Format Power BI TreeMap
  • Power BI Scatter Chart
  • Format Power BI Scatter Chart
  • Power BI Stacked Area Chart
  • Power BI Stacked Bar Chart
  • Format Stacked Bar Chart
  • Power BI Stacked Column Chart
  • Format Stacked Column Chart
  • Power BI Waterfall Chart
  • Format Power BI Waterfall Chart
  • Power BI 100% Stacked Bar Chart
  • 100% Stacked Column Chart
  • Create a Power BI Map
  • Format Power BI Map
  • Power BI Filled Map
  • Format Power BI Filled Map
  • Power BI Basic Filters
  • Power BI Slicer
  • Power BI Top 10 Filters
  • Power BI Drill through Filters
  • Power BI Filters on Measures
  • Power BI Advanced Filters
  • Power BI Report Level Filters
  • Power BI Page Level Filters
  • Power BI Calculated Columns
  • Add Conditional Column
  • Create Power BI Custom Column
  • Power BI Calculated Measures
  • Power BI Calculated Tables
  • Power BI DAX String Functions
  • Power BI DAX Math Functions
  • DAX Trigonometric Functions
  • Power BI DAX Date Functions
  • Power BI DAX Logical Functions
  • Power BI DAX Agg. Functions
  • Power BI Dashboard Introduction
  • Power BI Dashboard Settings
  • Power BI Dashboard Actions
  • Delete Power BI Dashboard
  • Subscribe Power BI Dashboard
  • Add Web Content to Dashboard
  • Add Image to Dashboard
  • Add video to power bi dashboard
  • Add Title to Power BI Dashboard
  • Pin Workbooks to Dashboard
  • Register to Power BI Service
  • Connect to Power BI Service
  • Create Power BI Workspace
  • Share Power BI Workspace
  • Create a Report in Workspace
  • Rename a Report in Workspace
  • Rename a Dataset in Workspace
  • Quick insights in Power BI
  • Get insights in Power BI
  • Publish power bi desktop report
  • Upload Power BI Workbooks
  • Upload Excel Files to Dashboard
  • Edit Power BI App
  • View Published Power BI App
  • Publish Power BI App
  • Share Power BI Dashboard
  • Share Power BI Workspace
  • Share Power BI Report
  • Power BI Q&A
  • Power BI Q&A Advanced
  • Customize Q&A Suggestions

Copyright © 2021· All Rights Reserved.
About | Contact | Privacy Policy