Power BI changes Yes/No values in Excel to True/False

[Anonymous]

Hello,

I have an Excel file in Sharepoint that I imported into a Power Bi dataset. The Excel file is actually populated by Microsoft Forms, if that matters. In the Excel file, there are columns with Yes/No values. When creating a pie chart, the values are changed to True/False (see image on left). When adding another value ("Thing" in this case), it shows correctly as seen in the image on the right. I've tried changing the field format in Excel to "Text" and added an apostrophe to the value to no effect.

Previously, I used a streaming dataset and Microsoft Flow to import the data into Power Bi, but the functionality seemed to be incredibly limited. Although, all the modeling/query editor features are still disabled. Therefore, I still can't add custom columns to try manipulate the value.

Please help.

[az38]

Hi @Anonymous 

If you want to use Yes/No as a Text, not boolean - go to the query editor (Edit Queries button), find column, then in Transform ribbon set Date type as Text

enjoy

do not hesitate to kudo useful posts and mark solutions as solution

[Anonymous]

Those options are disabled for me:

[v-chuncz-msft · Accepted solution]

@Anonymous 

Since this is a live connection, left-navigation and modeling are disabled. You may try adding measures.