Forum Discussion
formatting boolean values?
Hi everybody,
please excuse my total beginner question. I am lost :-)
I created a table with boolean values in Excel. It looks like this in Power BI:
How can I change the value “True” into something else? Preferably, a graphic icon? This is what I’m aiming for:
Many hanks for your suggestions and ideas
Ulrich
You're choosing #2 but based on what you're trying to do it looks like you really want #1.
For #1 you can go to the query editor, select all the columns, and do a replace values (replace True with the dot)
5 Replies
I really like this question - there are two ways to interpret what you're asking ...
1. How do I convert the Trues to Dots in the data itself?
OR
2. How do I convert the Trues to Dots in the visualization
For #2, Create a New Measure
NewMeasure = IF ( [Measure] = TRUE(), "●", BLANK() )
For #1, Prob Don't Want to Do This, but you would follow a similar if/then logic using the query editor
Hi Austin,
Thank you so much for your answer!
For my purpose I stick to choice #2, creating a new Measure.
Unfortunately, I get an error message when I use your DAX code:
I modified your DAX to:
DatabaseFormat = IF ( Themen[Database] = TRUE(); "●"; BLANK() )
The error message is in German (is there a way to change the language?). It basically says: No single value can be detected in the column Database of the table Themen. I also tried it without the table name (just: [Database]) and got a similar message.
Any idea what I'm doing wrong?
Ulrich
You're choosing #2 but based on what you're trying to do it looks like you really want #1.
For #1 you can go to the query editor, select all the columns, and do a replace values (replace True with the dot)
