Skip to main content




Let me show you how to add alternate row colors to Power BI table report with a practical example.

For this demo of adding alternate row colors to the Power BI table, we are going to use a table that we created in our previous post. I suggest you refer to the Create a table article to understand the same.

add-alternative-row-colors-to-power-bi-table-1-9720910

Add alternate row colors to the Power BI table sample

Click on the Format to see the list of available formatting options. Then navigate to Table style section to add alternate row colors to the table report.

In the following Power BI screenshot, you can see the list of styles that are available to design this table.

add-alternative-row-colors-to-power-bi-table-2-4978744

Please select the Alternate rows drop-down list option to add alternate row colors. Remember, this is the default option for any table.

add-alternative-row-colors-to-power-bi-table-3-5317033

Let me select the Alternate Row Contrast option

add-alternative-row-colors-to-power-bi-table-4-2338344

If you select Striking rows, then Power BI assigns the following colors.

add-alternative-row-colors-to-power-bi-table-5-4674399

If you select Bold header Striking rows, then Power BI assigns a black color to the headings and bold green colors to alternate rows.

add-alternative-row-colors-to-power-bi-table-6-5166759

For now, we're sticking with the default option (alternate rows). Then go to Values section to format the colors according to your requirement.

add-alternative-row-colors-to-power-bi-table-7-5967176

As you can see in the screenshot below, we changed the ForeColor and Back color of the odd and even rows. Here, we also change the font family to Cambria and the text size to 18

add-alternative-row-colors-to-power-bi-table-8-4825723

Then go to Column headers to alter the header colors.

As you can see in the screenshot below, we changed the font color to white, the background color to green. And the font family to Cambria, the text size to 25 and the alignment of the header text to the center.

add-alternative-row-colors-to-power-bi-table-9-6986985

Then go to Total section to modify the text and background color of Total.

As you can see in the screenshot below, we changed the Totals font color to white, the background color to green, the font family to Cambria, and the text size to 17.

add-alternative-row-colors-to-power-bi-table-10-3207259

Finally, you can see the alternative colors.

add-alternative-row-colors-to-power-bi-table-11-6494819




Let me show you how to add alternate row colors to Power BI table report with a practical example.

For this demo of adding alternate row colors to the Power BI table, we are going to use a table that we created in our previous post. I suggest you refer to the Create a table article to understand the same.

add-alternative-row-colors-to-power-bi-table-1-9720910

Add alternate row colors to the Power BI table sample

Click on the Format to see the list of available formatting options. Then navigate to Table style section to add alternate row colors to the table report.

In the following Power BI screenshot, you can see the list of styles that are available to design this table.

add-alternative-row-colors-to-power-bi-table-2-4978744

Please select the Alternate rows drop-down list option to add alternate row colors. Remember, this is the default option for any table.

add-alternative-row-colors-to-power-bi-table-3-5317033

Let me select the Alternate Row Contrast option

add-alternative-row-colors-to-power-bi-table-4-2338344

If you select Striking rows, then Power BI assigns the following colors.

add-alternative-row-colors-to-power-bi-table-5-4674399

If you select Bold header Striking rows, then Power BI assigns a black color to the headings and bold green colors to alternate rows.

add-alternative-row-colors-to-power-bi-table-6-2827276

For now, we're sticking with the default option (alternate rows). Then go to Values section to format the colors according to your requirement.

add-alternative-row-colors-to-power-bi-table-7-8249441

As you can see in the screenshot below, we changed the ForeColor and Back color of the odd and even rows. Here, we also change the font family to Cambria and the text size to 18

add-alternative-row-colors-to-power-bi-table-8-7433051

Then go to Column headers to alter the header colors.

As you can see in the screenshot below, we changed the font color to white, the background color to green. And the font family to Cambria, the text size to 25 and the alignment of the header text to the center.

add-alternative-row-colors-to-power-bi-table-9-2221760

Then go to Total section to modify the text and background color of Total.

As you can see in the screenshot below, we changed the Totals font color to white, the background color to green, the font family to Cambria, and the text size to 17.

add-alternative-row-colors-to-power-bi-table-10-2431691

Finally, you can see the alternative colors.

add-alternative-row-colors-to-power-bi-table-11-2212725




Let me show you how to add alternate row colors to Power BI table report with a practical example.

For this demo of adding alternate row colors to the Power BI table, we are going to use a table that we created in our previous post. I suggest you refer to the Create a table article to understand the same.

add-alternative-row-colors-to-power-bi-table-1-9720910

Add alternate row colors to the Power BI table sample

Click on the Format to see the list of available formatting options. Then navigate to Table style section to add alternate row colors to the table report.

In the following Power BI screenshot, you can see the list of styles that are available to design this table.

add-alternative-row-colors-to-power-bi-table-2-4978744

Please select the Alternate rows drop-down list option to add alternate row colors. Remember, this is the default option for any table.

add-alternative-row-colors-to-power-bi-table-3-5317033

Let me select the Alternate Row Contrast option

add-alternative-row-colors-to-power-bi-table-4-2338344

If you select Striking rows, then Power BI assigns the following colors.

add-alternative-row-colors-to-power-bi-table-5-4674399

If you select Bold header Striking rows, then Power BI assigns a black color to the headings and bold green colors to alternate rows.

add-alternative-row-colors-to-power-bi-table-6-5166759

For now, we're sticking with the default option (alternate rows). Then go to Values section to format the colors according to your requirement.

add-alternative-row-colors-to-power-bi-table-7-5967176

As you can see in the screenshot below, we changed the ForeColor and Back color of the odd and even rows. Here, we also change the font family to Cambria and the text size to 18

add-alternative-row-colors-to-power-bi-table-8-4825723

Then go to Column headers to alter the header colors.

As you can see in the screenshot below, we changed the font color to white, the background color to green. And the font family to Cambria, the text size to 25 and the alignment of the header text to the center.

add-alternative-row-colors-to-power-bi-table-9-2221760

Then go to Total section to modify the text and background color of Total.

As you can see in the screenshot below, we changed the Totals font color to white, the background color to green, the font family to Cambria, and the text size to 17.

add-alternative-row-colors-to-power-bi-table-10-3207259

Finally, you can see the alternative colors.

add-alternative-row-colors-to-power-bi-table-11-5525988
R Marketing Digital