How to Bold Certain Rows in Power BI Matrix

Making a single row in a Power BI matrix bold seems like it should be simple, but it's a feature that often leaves users searching for a solution. While there's no one-click button, you can absolutely achieve this and make your reports significantly easier to read. This guide will walk you through exactly how to bold specific rows in a Power BI matrix using conditional formatting and a touch of DAX.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bolding Rows in a Matrix Matters

Before jumping into the steps, it’s worth understanding why this is such a powerful formatting technique. A well-structured matrix can display a ton of information, but without visual cues, it can quickly become a wall of numbers. Bolding specific rows helps you:

• Draw Attention: Your audience’s eyes will naturally gravitate toward the bolded information, making it perfect for highlighting totals, specific product categories, top-performing regions, or any data point that needs emphasis.
• Improve Readability: Bolding creates a clear visual hierarchy. It breaks up monotonous data and helps users scan and understand the structure of your report, especially in matrices with multiple levels of grouping (e.g., Category and Subcategory).
• Create Professional Reports: Clean, intentional formatting makes your dashboards look more polished and easier to digest. It transforms a basic data table into a professional, presentation-ready visual.

The Core Method: Combining DAX and Conditional Formatting

The secret to bolding an entire row lies in Power BI’s conditional formatting feature. However, you can't just apply it directly to a row. Instead, you apply it column by column, driven by a simple rule you create with a DAX (Data Analysis Expressions) measure.

Don't let the term "DAX" scare you. For this task, we’ll use very simple formulas. Here’s the basic idea:

1. Create a DAX measure: This measure will act as our "rule." It will check each row in our matrix and decide if it meets a specific condition (e.g., is this a subtotal row? Is this the "Software" category?).
2. Set the output: If the condition is met, the measure will output a formatting instruction, like a dark color (e.g., black). If not, it will output a lighter color (e.g., grey).
3. Apply the rule: We’ll tell Power BI to use this DAX measure's output to control the font color for each column in our matrix. When every column in a row has a black font, the entire row appears bold.

Let's walk through a common example: bolding the subtotal rows.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Guide to Bolding Subtotal Rows

Imagine you have a matrix showing Sales by Product Category and Subcategory. The default view includes a subtotal for each Category, but they blend in with the rest of the data. Let’s make them stand out.

Step 1: Create the DAX Measure for Logic

First, we need to write a measure that can identify when a row is a Category total versus a Subcategory detail row. The DAX function ISINSCOPE() is perfect for this.

• Navigate to the Modeling tab in the Power BI ribbon and click on New Measure.
• Enter the following DAX formula into the formula bar. Be sure to replace 'Products'[Subcategory] with the actual column that represents the lowest level of detail in your matrix hierarchy.

Format Subtotal Bold = IF(ISINSCOPE('Products'[Subcategory]), "Gray", "#000000")

Breaking Down the Formula:

• IF(...): This is a standard conditional check.
• ISINSCOPE('Products'[Subcategory]): This returns TRUE if the current row is at the Subcategory level (the most detailed level) and FALSE if it’s at a higher level (the Category subtotal).
• "Gray": If the expression is TRUE (it's a detail row), we set the font color to gray.
• "#000000": If the expression is FALSE (it's a subtotal row), we set the font color to black. #000000 is the hex code for black, which creates the bold effect.

Step 2: Apply the Conditional Formatting

Now that we have our formatting rule, we need to apply it to every value field in our matrix. For this example, let's assume we have a "Total Sales" column.

• Select your matrix visual on the report canvas.
• Open the Format your visual pane (the paintbrush icon).
• Expand the Cell elements section.
• In the "Apply settings to" drop-down, select your value column (e.g., Total Sales).
• Turn on the toggle for Font color. This will open an options window.
• In the pop-up window, configure the following:
• Click OK.

You'll immediately see the "Total Sales" values for your subtotal rows turn black, while the detail rows become gray, creating a powerful bolding effect and improving readability.

Important Note: To make the entire row appear bold, you must repeat Step 2 for every single column (every "Cell element") in your matrix that you want to be included in the formatting.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Format the Row Headers

You've formatted the values, but what about the category name itself? We can use the same technique on the row headers.

• With the matrix still selected, navigate back to the Format your visual pane.
• Expand the Row headers section.
• Expand the Values section inside Row headers.
• Find the Font color option and click the fx button next to it.
• In the pop-up window, use the exact same settings as before:

Click OK.

Now, your subtotal category names will also be black, and the subcategory names will be gray, completing the polished, hierarchical look.

Advanced Method: Bolding a Specific Row by Value

What if you don't want to bold a subtotal, but a specific category instead? For example, your company is launching a big campaign for the "Computers" category and you want it to stand out in every report. The process is very similar, we just need a slightly different DAX measure.

Step 1: Create a Value-Specific DAX Measure

• Create a new measure.
• Enter the following DAX formula, replacing 'Products'[Category] and "Computers" with your column and the specific value you want to highlight.

Format Specific Category Bold = IF(SELECTEDVALUE('Products'[Category]) = "Computers", "#000000", "Gray")

Breaking Down This Formula:

• SELECTEDVALUE('Products'[Category]): Checks the value of the 'Products'[Category] column for the current row.
• = "Computers": Compares that value to "Computers".
• If the value matches, it returns black (#000000). Otherwise, it returns gray.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 2: Apply the New Measure

Follow the exact same steps outlined previously to apply this new measure (Format Specific Category Bold) to the font color of each of your cell elements and row headers. This flexible technique allows you to highlight any specific row based on its value.

Common Pitfalls and Best Practices

• Remember to Apply to All Columns: The most common mistake is applying the conditional formatting to only one value column. For the whole row to look bold, you must systematically apply the rule to the font color of every cell element and the row headers.
• Hex Codes vs. Color Names: Power BI recognizes basic color names like "Black", "Gray", and "Red". For more control over specific shades, use hex codes (e.g., "#333333" for a dark gray).
• Managing Multiple Measures: If you use this technique often, give your formatting measures descriptive names like [CFormat] Font Color - Subtotal to keep them organized.
• It's Not Technically Bold: Remember, we aren't actually changing the font weight to "Bold." We are changing the color contrast to create a strong visual effect. This is the standard and accepted workaround in Power BI for achieving this result.

Final Thoughts

By mastering the combination of a simple DAX measure and conditional formatting, you can take your Power BI matrices from basic tables to clean, insightful visuals. This method allows you to guide your audience’s focus, improve readability, and ultimately tell a clearer story with your data by making key information stand out.

Setting up DAX rules and manually applying formatting column-by-column can feel cumbersome, especially when you need to create reports quickly. At Graphed, we felt this pain, which is why we built an AI data analyst that handles the setup for you. Instead of navigating formatting panes, you could simply ask, "create a report of sales by product category and highlight all computer sales." We automate the process of connecting data and building visualizations so you can get from question to insight in seconds, not hours.