Forum Discussion

Lanzette's avatar
Lanzette
Regular Visitor
10 years ago
Solved

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 valu...
Need Help
  • austinsense's avatar
    austinsense
    10 years ago

    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)

     

austinsense's avatar
austinsense
Impactful Individual
10 years ago

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's avatar
Lanzette
Regular Visitor
10 years ago

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