How to Change Power BI X-Axis Labels from True/False to Yes/No
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".

- 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 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.
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.
Launch Power BI Desktop and click on the 'Data' icon on the left-hand navigation pane to view your tables.
Select the table containing your target data. Go to the 'Table tools' tab in the top ribbon and click on 'New column'.
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.
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.

Replace Values in Power Query Editor
Transform the data directly in Power Query before it loads into your model to permanently change the values across all future visuals.
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. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the Software: Run the downloaded installer and follow the simple on-screen prompts to set up the software.
- 3. Open and Analyze: Launch WPS Spreadsheet and easily import your Excel or CSV datasets to start creating customized, professional charts.

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.




