What To Do When Your Power BI Pie Chart Is Not Showing Data

how-to Mar 03, 2024
What To Do When Your Power BI Pie Chart Is Not Showing Data
Profile Image
Hi, I'm Tom Blessing. I'm an expert at helping small to mid-sized companies adopt Power BI. I'm also a recovering investment banker, with deep experience applying technology to otherwise manual data problems. I have dual degrees in Finance and Technology Management from Indiana University.

Resources to help build your fundamentals: Learning Power BI? Data fundamentals are critical for this process to be easier. I've assembled a few DataCamp courses to help. I earn a small commission if you click and purchase.

Introduction to Power BI course: Master Power BI basics and learn to build impactful reports.

Exploratory Data Analysis in Power BI course: Learn about Power BI's Exploratory Data Analysis (EDA) and enhance your reports.

Introduction to SQL course: Learn how to create and query relational databases using SQL in just two hours.

Introduction to DAX course: Learn the fundamentals of Data Analysis Expressions (DAX) such as calculated columns, tables, and measures.

Database Design course: Learn to design databases in SQL to process, store, and organize data in a more efficient way.

Among Power BI's wide array of visualization options, the pie chart is a commonly used tool for displaying data distribution and proportions.

However, there are instances when the Power BI pie chart may not show data correctly or at all.

In this blog post, we'll explore the possible reasons behind this issue and offer practical solutions to troubleshoot and resolve it.

Data Formatting Issues:

One of the primary reasons for a Power BI pie chart not displaying data is data formatting problems. Pie charts require a single numerical value to represent each slice. If the data source contains non-numeric or improperly formatted values, it can prevent the pie chart from rendering correctly.

Solution: Double-check your data source and ensure that the data you want to display in the pie chart is in numeric format. If needed, use Power Query Editor to clean and format your data correctly.

Aggregation or Grouping:

Power BI pie charts typically work best when you're representing aggregated or summarized data. If you're trying to display individual data points or haven't applied the necessary aggregation, it can result in a blank or misleading chart.

Solution: Ensure that you're using aggregation functions (e.g., sum, count) in your data model or within the pie chart's values section to summarize your data accurately.

Incorrect Data Binding:

Another common issue is incorrect data binding within the pie chart. You need to ensure that you have selected the correct field for the "Values" section of the pie chart visualization.

Solution: Review the pie chart properties and verify that you have bound the appropriate numerical field to the "Values" section. Correct any mismatches.

Data Filtering:

If you've applied data filtering at the report level or slicer level, it may affect what data is displayed in your pie chart. If the filter settings exclude the data you want to visualize, the chart may appear empty.

Solution: Review your report's filter settings to ensure they include the data you want to display in the pie chart. Adjust filters as needed to include the relevant data.

Data Relationships:

Power BI relies on relationships between tables to display data correctly in visualizations. If your data model lacks the necessary relationships, it can lead to issues with pie chart data display.

Solution: Check your data model for proper relationships between tables. Ensure that tables are related correctly to the data you intend to visualize in the pie chart.

Visual Settings:

Sometimes, the pie chart may not display data due to incorrect visual settings. Check the chart's formatting options, labels, and color schemes to ensure they are set correctly.

Solution: Review and adjust the visual settings of your pie chart to ensure it accurately represents your data. Make sure that labels, legends, and colors are configured appropriately.


While Power BI pie charts are a powerful tool for visualizing data distribution, they can encounter issues related to data formatting, aggregation, binding, filtering, relationships, or visual settings. By troubleshooting these common problems and following the solutions outlined in this blog post, you can ensure that your pie chart effectively communicates data proportions and insights. Remember to pay close attention to data formatting and ensure that your data model is correctly structured to avoid potential issues with pie chart visualization.


Download My Free Guidebook

The 3-Step Plan for Getting Started With PowerBI

Learn the best way I've helped large and small companies adopt the best analytics tool you've ever seen. In this FREE guide, I'll show you my complete startup strategy for Power BI.

We hate SPAM. We will never sell your information, for any reason.