Conditional formatting in tables in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is conditional formatting in Power BI tables?

Conditional formatting changes the look of table cells based on their values. It helps highlight important data like high sales or low stock.

beginner

How do you apply conditional formatting to a column in a Power BI table?

Select the table visual, go to the Format pane, find the column under 'Conditional formatting', and choose the type like background color or font color.

beginner

Name two types of conditional formatting you can use in Power BI tables.

You can use background color and font color formatting. Both change colors based on cell values to make data easier to read.

intermediate

What is a color scale in Power BI conditional formatting?

A color scale uses a gradient of colors to show value ranges. For example, low values might be red and high values green, with colors in between.

beginner

Why use conditional formatting in tables?

It helps you quickly see trends, outliers, or important numbers without reading all data. It makes reports clearer and faster to understand.

Where do you find conditional formatting options for a table in Power BI?

A In the Data view tab

B In the Format pane under the specific column

C In the Home ribbon

D In the Query Editor

Conditional formatting for tables is set in the Format pane when you select the table visual and then the column.

Which of these is NOT a type of conditional formatting in Power BI tables?

A Background color

B Font color

C Pivot table

D Data bar

Pivot table is a type of table, not a conditional formatting option.

What does a color scale do in conditional formatting?

A Shows a gradient of colors based on values

B Changes font size

C Sorts the table rows

D Filters data automatically

Color scales apply a gradient of colors to cells depending on their values.

Why is conditional formatting useful in tables?

A To highlight important data quickly

B To add formulas

C To create new columns

D To export data

Conditional formatting highlights key data points visually.

Can you apply conditional formatting to multiple columns at once in Power BI tables?

A No, conditional formatting is not available

B No, only one column at a time

C Yes, by using the Query Editor

D Yes, by selecting each column and setting formatting

You can apply conditional formatting to multiple columns by selecting each column and setting formatting individually.

Explain how to add background color conditional formatting to a column in a Power BI table.

Think about the steps in the Format pane for a table.

Describe why conditional formatting helps when analyzing data in tables.

Consider how colors or styles guide your eyes.