Forum Discussion
formatting boolean values?
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)
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)
Hi Austin,
for some reason I can't get the New Measure method to work. But #1 (replacing the values in the query editor) worked out great.
Thanks very much for your help
Ulrich
If we could create KPIs within PBI this would have been easier
Currently you have to create in PowerPivot and Import to PBI
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-and-display-kpis/
If you'd like to be able to do this in PBI Vote here
