How to Highlight in Power BI

Highlighting data in your Power BI reports is one of the fastest ways to turn a dense dashboard into a clear, actionable story. It guides your audience’s attention to the most important metrics, making your key insights immediately stand out. This tutorial covers several powerful methods for highlighting in Power BI, from simple conditional formatting to dynamic, interactive techniques.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Highlight Instead of Filter?

Before jumping into the "how," it's important to understand the difference between highlighting and filtering, as they serve distinct purposes. When you filter a visual, you remove any data that doesn’t meet your criteria. If you filter a sales report to only show the "West" region, all other regions disappear from the chart. This is useful for focusing on a specific subset of data.

Highlighting, on the other hand, keeps all the data visible but emphasizes a specific portion. In our sales report example, clicking to highlight the "West" region would show its sales bar in a bright, saturated color, while the bars for the North, South, and East regions would fade into the background. This approach is powerful because it draws attention to the West's performance while preserving the overall context of how it compares to other regions.

Use filtering when you need to isolate data. Use highlighting when you need to compare a subset against the whole.

Mastering Conditional Formatting for Highlighting

Conditional formatting is your primary tool for automatically applying visual highlights to tables, matrices, and many other charts based on data values. It allows you to set up rules that color cells, text, or data bars, making it easy to spot trends, outliers, and key performance indicators at a glance.

You can find the conditional formatting options by selecting a visual, going to the Visualizations pane, clicking the Format your visual icon (the paintbrush), and expanding the Cell elements section (for tables and matrices) or a similar section like Columns or Bars for other chart types.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Highlighting with a Background Color Scale (Gradient)

A color scale, or gradient, is perfect for showing the distribution of values across a spectrum. For instance, you could quickly see which products have the highest sales - they’d be shaded dark green, while lower-performing products would be light green or red.

Follow these steps to set it up:

1. Select your visual, like a table or matrix.
2. In the Format your visual pane, go to Cell elements.
3. In the drop-down, select the column you want to highlight (e.g., ‘Revenue’).
4. Turn on the Background color toggle. An 𝑓𝑥 icon will appear.
5. Click the 𝑓𝑥 icon to open the formatting window.
6. For Format style, select Gradient. This is often the default.
7. You can set colors for the Minimum, Maximum, and optionally, a Center value. For example, you might set the minimum to red and the maximum to green to show performance.
8. Click OK. Your table cells will now be colored based on their values relative to the others.

Highlighting Based on Specific Rules

Sometimes you don't need a spectrum, you need to highlight data that meets very specific criteria. For example, you might want to highlight any inventory count below 50 units in red or any sales rep who exceeded their quota in green. This is where rules-based formatting shines.

Here’s how to apply it:

1. Follow the first five steps from the gradient example above.
2. In the formatting window, change the Format style to Rules.
3. Define your rules under the Rules section. For this, you’ll define conditions based on the value of the numeric field.
4. For example, to highlight profit margins, you could create these rules:
5. Click OK. Power BI will now apply the specific background color that matches the conditions you set for each row.

Using Icons and Data Bars for Emphasis

In the same Cell elements menu, you can also apply Icons or Data bars. Icons let you add visual indicators like traffic lights, flags, or checkmarks based on rules. Data bars create small, in-cell bar charts that make it very simple to compare relative values without leaving the table.

Both options add an excellent layer of quick, scannable context, a form of highlighting that brings your tables to life.

Interactive Highlighting: Connecting Your Visuals

Power BI's real power comes from its interactivity. By default, visuals on the same report page are linked. When you click on a data point in one visual, it cross-highlights or cross-filters the other visuals on the page, revealing relationships in the data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How Cross-Highlighting Works by Default

Imagine a report Page with two visuals: a bar chart showing Sales by Country and a pie chart showing Sales by Product Category. If you click on the "USA" bar in the first chart, the pie chart will automatically update. The portions of the pie representing sales in the USA will remain brightly colored, while the portions representing sales from other countries will be faded out. This instantly shows you which product categories are most popular in the USA.

This default interaction makes it easy for users to explore the data dynamically without any extra setup from the report creator.

Editing Visual Interactions

While the default behavior is useful, you sometimes need more control. You might want one visual to filter another instead of just highlighting it, or you might want to disable the interaction entirely. Power BI lets you customize this.

Here's how to manage visual interactions:

1. First, select the visual that will act as the "source" (the one users will click).
2. Navigate to the Format tab in the ribbon at the top of the Power BI Desktop window.
3. Click on Edit interactions.
4. You'll now see small icons appear in the corner of all other visuals on the page when the source visual is selected. These icons let you choose the interaction type:
5. For each other visual on the page, click the icon that represents the interaction you want. For example, you might want your country map not to be affected by other visuals, so you’d select the ‘None’ icon on it while your map slicer is selected for edits.
6. Once you're done, click Edit interactions again to turn off editing mode.

Mastering visual interactions allows you to build highly intuitive and guided analytical experiences for your end-users.

Advanced Highlighting Techniques

Once you’re comfortable with the basics, you can use more advanced methods to create even more insightful reports, including leveraging calculations with DAX.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Dynamic Highlighting with DAX

For the ultimate flexibility, you can use DAX (Data Analysis Expressions) measures to control highlighting. This allows you to create highlighting rules based on complex business logic that isn't possible with the standard formatting menu.

Let’s say you want to highlight all sales that are above the average sale amount for whatever data is currently being viewed. Since the average changes depending on the filters applied, this needs to be dynamic.

Step 1: Create a DAX Measure for the Color

First, create a new measure that returns a hex color code. Go to the "Modeling" tab and click "New Measure." Enter a formula like this:

Highlight Above Average Sale = 
VAR AverageSale = AVERAGEX(ALLSELECTED('Sales'), 'Sales'[Total Revenue]) 
VAR CurrentSale = SELECTEDVALUE('Sales'[Total Revenue]) 
RETURN 
IF(CurrentSale > AverageSale, "#01B8AA", "#F2C811")

What this formula does:

• It calculates the average revenue across all currently selected data (ALLSELECTED makes it respond to filters).
• It gets the value of the revenue for the current row (SELECTEDVALUE).
• If the current sale is above average, it returns a teal hex code (#01B8AA). Otherwise, it returns a yellow hex code (#F2C811).

Step 2: Apply the DAX Measure in Conditional Formatting

1. Select the visual you want to format (e.g., a table with the ‘Total Revenue’ column).
2. Go to Format your visual > Cell elements.
3. Turn on Background color and click the 𝑓𝑥 button.
4. In the Format style drop-down, select Field value.
5. In the field selector below ("What field should we base this on?"), choose your new measure, Highlight Above Average Sale.
6. Click OK.

Now, your visual will automatically highlight rows based on your dynamic DAX logic. When a user applies a filter—for example, selecting a specific year—the average recalculates, and the highlighting updates instantly. This is an incredibly powerful way to embed advanced analytics directly into your visuals.

Final Thoughts

Learning how to highlight effectively in Power BI transforms static numbers into a dynamic and conversational dashboard. By using conditional formatting, editing visual interactions, and even applying DAX measures, you can guide your users directly to the insights that matter most, making your reports more impactful and easier to understand.

Mastering Business Intelligence tools is a massive advantage, but often the real slowdown isn't building the report - it's the tedious, manual work of just getting your data in one place. Pulling CSVs from all your separate marketing and sales platforms like Google Analytics, Shopify, and Facebook Ads can take up hours of your week before you even get to start. With Graphed, we automate that entire exhausting process. We help you connect all your data sources into one place instantly, so you can build real-time dashboards and get answers from your data just by asking questions in simple, natural language.