formatting boolean values?

[Lanzette]

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

[austinsense]

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

[Lanzette]

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

[austinsense · Accepted solution]

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)

[Lanzette]

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

[Sean]

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

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8276622-create-kpi-in-designer-fi...