Others

Fix Power BI Pie Chart Showing 100% After Selecting a Slicer

Kushani Nimanthika Sep 28, 2026 869 views

Question details

The user needs to display the correct percentage of a specific category in a Power BI pie chart when applying a slicer, rather than the chart defaulting to 100%.

How to Fix Power BI Pie Chart Showing 100% After Selecting a Slicer

Product: Microsoft Power BI
Device & OS: not provided
Scenario: Filtering a pie chart using a gender slicer to view the proportion of a specific gender's exits against the grand total of all customer exits.
Observed behavior: When a specific gender is selected in the slicer, the pie chart visual updates to show 100% instead of its actual percentage of the overall dataset.

Before you start

Ensure you have permission to edit the dataset in Power BI Desktop and are familiar with creating new DAX measures in the Data pane.

Solution 1Recommended

Create a DAX Measure to Ignore the Slicer Filter

Use the DAX CALCULATE and ALL functions to bypass the slicer's context filter, ensuring the total calculation remains static regardless of the selection.

By default, selecting an item in a Power BI slicer applies a filter context to the entire visual. If you filter by 'Female', the visual only sees 'Female' data, making it 100% of the visible context. To solve this, you must calculate the grand total by removing the slicer filter using the ALL() function, and then perform the division.

Open the Data pane

Launch Power BI Desktop, open your report, and locate the Fields/Data pane on the right side of the screen.

Create a measure for Total Exits

Right-click your target table (e.g., Bank_Departure) and select 'New measure'. Enter the formula to ignore the gender filter: Total Exits = CALCULATE([Exit Customers], ALL(Bank_Departure[GenderID])).

Create the Exit Ratio measure

Right-click the table again and create a second measure to calculate the percentage: Exit Ratio = DIVIDE([Exit Count], [Total Exits]).

Update the Pie Chart visual

Select your pie chart visual. In the Visualizations pane, replace the original values field with your newly created 'Exit Ratio' measure.

Create a DAX Measure to Ignore the Slicer Filter

Format as Percentage: Select the 'Exit Ratio' measure in the Data pane and click the '%' icon in the Measure tools ribbon to ensure it displays correctly as a percentage in your pie chart.

Free Microsoft Office alternative

Need to Analyze Data and Create Charts Easily? Try WPS Office

While Microsoft Power BI handles highly complex data models, everyday data analysis, pivot tables, and charting can be managed much faster in spreadsheets. WPS Spreadsheet offers a free, lightweight alternative with powerful visualization tools.

1. Open your dataset: Launch WPS Spreadsheet and open your .xlsx or .csv data file.
2. Select your data: Highlight the columns and rows containing the categories and values you want to visualize.
3. Insert a chart: Go to the 'Insert' tab on the top ribbon, click 'Chart', and select 'Pie Chart' to instantly generate a visualization showing accurate percentages.

Free and lightweight office suite for Windows, Mac, and LinuxFully compatible with Microsoft Excel (.xlsx) formats and formulasEasy-to-use Pivot Tables and charting tools for rapid data analysisFamiliar user interface allowing seamless migration with no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power BI visual show 100% when a slicer is applied?

Power BI slicers apply a strict filter context to visuals. When you select a single category, that category becomes the entire context for the visual, meaning it accounts for 100% of the visible data. You must use DAX formulas to override this behavior.

What is the difference between ALL() and ALLSELECTED() in DAX?

The ALL() function completely ignores all filters on the specified table or column, always returning the grand total. ALLSELECTED() ignores the visual's internal row/column context but respects external filters applied by the user via slicers.

Can I keep the pie chart showing all categories while highlighting the selected one?

Yes, but it requires advanced DAX. Instead of using a standard column for the slicer, you create an unlinked parameter table for the slicer and write a DAX measure that dynamically groups data into 'Selected Category' and 'Others' based on the user's choice.

Office Quick Solutions