How to Remove Count from Y Axis in Power BI

It's a frustratingly common Power BI moment. You meticulously craft a visual, drag your fields into place, and just when you expect a clean, professional-looking chart, the Y-axis proudly displays "Count of Product Name." You didn't want a count, you wanted the actual product names listed. This little quirk can derail newcomers and annoy even seasoned users, turning a simple task into a hunt through menus. This guide will show you not only how to fix it but also explain why it happens so you can prevent it in the future.

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 Power BI Insists on Counting (And When It's Actually Useful)

Before diving into the fix, it helps to understand what Power BI is trying to do. At its core, Power BI is an analytics tool designed to aggregate, or summarize, large amounts of data. When you place a field into a value area of a chart - like the Y-axis of a bar chart or the Values section of a matrix - Power BI’s default behavior is to perform a calculation on it.

If the data is numeric (like Sales Amount), it will instantly default to summing it up (Sum of Sales Amount). This is usually what you want. However, if the data is text-based (like a Product Name, Sales Rep, or City), Power BI can't perform math on it. It can't add "Laptop" and "Mouse" together. So, it does the next logical thing from its perspective: it counts how many times each item appears.

This is extremely useful when your goal is to see frequency. For example, you might want a chart showing:

• The number of sales made by each sales representative.
• The count of customers in each city.
• The number of support tickets logged for each product category.

In these cases, "Count of Sales Rep" is exactly the insight you need. The trouble arises when you're using that text-based field not as a value to be counted, but as the category or label for your values. That's when you need to tell Power BI to stop summarizing.

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

The Quickest Fix: Let's Stop Summarization on the Y-Axis

Let's say you're building a simple horizontal bar chart to show Sales Amount by Product Category. You drag 'Product Category' to the Y-axis field well and 'Sales Amount' to the X-axis. But instead of seeing "Electronics," "Apparel," and "Home Goods" on the axis, you just get a single bar labeled "Count of Product Category." Here's the most direct way to fix it.

This happens when you accidentally drag your category field into a section of the visual meant for numerical values. Your intention was to use it as an axis label. The fix is often as simple as moving the field to the correct place.

Step-by-Step Guide to Placing Your Fields Correctly

1. Select your visual: Click on the chart on your Power BI canvas to make it active. This will bring up the Visualizations pane on the right-hand side.
2. Inspect the field wells: Look at the fields under the visual's settings. For a standard bar or column chart, you will see wells for the X-axis, Y-axis, Legend, etc.
3. Move the field to the correct Axis well: In our example, 'Product Category' was likely dragged into the Values well instead of the Axis well (or Y-axis for a horizontal bar chart). Click and drag the "Count of Product Category" pill from the Values section and drop it into the "Y-axis" well. It should now appear as just 'Product Category.'

If your field is in the correct axis well but is still showing a count, you've run into a different version of the same issue. This can sometimes happen with numeric fields that you want to use as labels, and Power BI has decided to summarize them automatically.

When Your Field is Also the Value

Sometimes you just want to list items without an associated measure. Maybe you want to create a simple list of categories in a table visual. In this case, Power BI might still try to count them. This is where the 'Don't Summarize' command comes in handy.

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-by-Step Guide to "Don't Summarize"

1. Select your visual: Click on your chart or table to activate it.
2. Locate the field in the Visualizations pane: Find the field that is being improperly counted. It will likely have a "Count of..." prefix.
3. Click the dropdown arrow: Next to the field name, there is a small downward-facing arrow or chevron. Click it to open the context menu.
4. Select "Don't Summarize": In the dropdown menu, you will see a list of possible aggregations like Sum, Average, Minimum, Maximum, and Count. You need to choose the "Don't Summarize" option. Once you select it, the field will change from an aggregated value to a list of its individual items.

Presto! The "Count of" prefix vanishes, and your axis now displays the individual category names as you originally intended.

Handling Numeric Identifiers You Don't Want to Average or Sum

This "unwanted counting" issue is especially common with numbers that aren't really numbers - they're identifiers. Think about fields like:

• Zip Codes
• Order IDs
• Customer IDs
• Years (sometimes)

Power BI sees a column of numbers and immediately thinks it should sum or average them. Adding up zip codes or averaging order IDs makes zero analytical sense. This is not just a visual problem, it can lead to fundamentally incorrect reports if left unchecked. You're not just fighting the "Count of" issue here, but also "Sum of" and "Average of." The solution is to explicitly tell Power BI that these numbers are labels, not values.

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

How to Re-Categorize Your Data

The best way to fix this long-term is by changing the data type or default summarization in the Data Model itself. This will save you from having to adjust it in every single visual you create.

Option 1: Change the Data Type

This is the most robust solution for identifiers like Zip Codes or Product SKUs that happen to be numbers.

1. Navigate to the Data View in Power BI (the spreadsheet-like icon on the left-hand rail).
2. Select the table that contains your column.
3. Click on the header of the column you want to change (e.g., 'ZipCode').
4. A "Column tools" tab will appear in the top ribbon. Within this ribbon, you will see a "Data type" dropdown (it will likely say Whole number or Decimal number).
5. Change the data type to Text.

Power BI will now treat that column as a list of text labels. It won't try to add, average, or perform any mathematical operations on it ever again. When you drag it onto a visual as an axis, it will behave correctly from the start.

Option 2: Change the Default Summarization

This method is perfect for numeric fields that you might occasionally want to count but generally use as a category, like 'Year'.

1. Again, go to the Data View and select the column (e.g., 'SaleYear').
2. With the column selected, look at the "Column tools" ribbon.
3. Find the "Summarization" property group. Click the dropdown that likely says "Sum."
4. Change this to "Don't summarize."

Now, whenever you pull this 'SaleYear' field into a visual, it will default to showing a list of years (2021, 2022, 2023) instead of trying to sum them (SUM of SaleYear = 6066). This proactive step cleans up your reporting process dramatically and prevents the same little annoyance from popping up over and over.

Final Thoughts

Mastering Power BI often means learning how to override its helpful-but-sometimes-misguided defaults. That "Count of" message on your Y-axis is simply the tool trying to summarize text data, and once you know how to toggle summarization or properly categorize your data, you are back in full control of your visualizations.

That kind of manual adjustment - wrangling data models and hunting for dropdown menus - is part of the steep learning curve of traditional BI tools. We know how much time that process can consume because we've lived it. With Graphed , you simply describe what you need in plain English. Instead of fixing axes, you ask, "Show me revenue by marketing campaign as a bar chart," and get the right chart instantly, connected to your live marketing and sales data. We built it to turn hours of data wrangling into 30-second conversations, so you can focus on insights, not settings.