Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous
Since this is a live connection, left-navigation and modeling are disabled. You may try adding measures.
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
Those options are disabled for me:
@Anonymous
Since this is a live connection, left-navigation and modeling are disabled. You may try adding measures.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |