Others

How to Change Power BI X-Axis Labels from True/False to Yes/No

Camila MilosovichCamila Milosovich Oct 15, 2026 870 views

Question details

The user needs to replace the default "True", "False", and "Blank" values on a Power BI chart's X-axis with more readable text labels such as "Yes", "No", and "N/A".

How to Change Power BI X-Axis Labels from True/False to Yes/No
Product
Microsoft Power BI
Device & OS
not provided
Scenario
Visualizing dataset trends in a Power BI chart where boolean or missing values populate the X-axis fields.
Observed behavior
The X-axis currently displays raw data values (Blank, True, False) instead of customized, user-friendly labels.
Before you start

Before modifying your data labels, ensure you have edit permissions for the dataset in Power BI Desktop and verify that altering these column values won't break other existing visuals in your report.

Solution 1Recommended

Create a Calculated Column Using DAX

Use a DAX formula to create a new column that automatically translates the boolean values into your preferred text labels for the chart.

This method is highly recommended as it preserves your original data column while giving you a dedicated, formatted field specifically for chart visuals.

1
Open the Data View

Launch Power BI Desktop and click on the 'Data' icon on the left-hand navigation pane to view your tables.

2
Add a New Column

Select the table containing your target data. Go to the 'Table tools' tab in the top ribbon and click on 'New column'.

3
Enter the DAX Formula

In the formula bar, enter a conditional statement such as: CustomLabel = IF(ISBLANK([YourColumn]), "N/A", IF([YourColumn] = TRUE(), "Yes", "No")). Press Enter to apply.

4
Update Your Visual

Switch back to the 'Report' view, select your chart, remove the old boolean column from the X-axis field well, and drag in your new 'CustomLabel' column.

Create a Calculated Column Using DAX
Tip: You can further customize the DAX output string to match any specific terminology required by your organization.
Free Microsoft Office alternative

Enhance Your Data Analysis with WPS Office Spreadsheet

While Power BI is designed for complex business intelligence, WPS Office Spreadsheet provides a lightweight, highly compatible alternative for everyday data processing, chart creation, and data transformation without a steep learning curve.

  1. 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install the Software: Run the downloaded installer and follow the simple on-screen prompts to set up the software.
  3. 3. Open and Analyze: Launch WPS Spreadsheet and easily import your Excel or CSV datasets to start creating customized, professional charts.
Fully compatible with Microsoft Excel (.xlsx, .csv) formats for seamless data import and export.Free and lightweight data visualization tools for quick chart creation.Familiar spreadsheet interface that requires zero learning curve.Built-in data filtering and advanced formula support to easily replace True/False values.
microsoft office alternative - wps office

Frequently Asked Questions

Can I format the original boolean column directly without creating a new one in Power BI?

In Power BI, you cannot natively apply a custom text format directly over a boolean (True/False) data type to display as Yes/No on an axis. You must either create a calculated column using DAX or transform the raw data via the Power Query Editor.

Will changing values in Power Query affect my original database?

No, transformations made in Power Query only affect the data loaded into the local Power BI model. Your original source database or spreadsheet remains completely unchanged.

Why does my chart still show blanks after creating a calculated column?

Ensure that your DAX formula explicitly handles ISBLANK() or NULL values before evaluating the True/False conditions. Additionally, verify that the new calculated column has actually replaced the old one in your visual's X-axis field settings.

Where can I get more specialized help for complex Power BI queries?

For highly specialized DAX formulas or complex data modeling troubleshooting, posting your question in the official Microsoft Power BI Community forums is highly recommended.