Need help conditional formatting True/False values in a column with other different values.

[Anonymous]

Hi Power BI Community,

I'm trying to conditionally format this table that has True/False values as well as numbers. I would like True to be highlighted in Green and False be red...while the remaining values remain neutral. Please see the image and let me know if I can provide any addtional information.

Thanks!

[v-xulin-mstf]

Hi @Anonymous,

You need a measure as below:

Measure = SELECTEDVALUE( 'Table'[Column1] ) + 0

Then in  the table visual, right click on the column field>choose conditional formatting>Background color:

Then make the setting as below:

And you will see:

Here is the demo, please try it.

Best Regards,

Link

[Anonymous]

Hi @v-xulin-mstf, I was able to create the measure. However when I go to apply it to the column, I get the error that I "cannot convert value 'FALSE' of type Text to type Number. Is there another work around for this?

Also I tried to click through to the demo but it states that I do not have access to the sharepoint. 

Thank you!

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

Sorry, please try this.

The measure is to apply condition format as:

Could you provide details about your issue?

Best Regards,

Link

[Anonymous]

Thank you! It finally worked. I need to change the data type. 

[PhilipTreacy]

@Greg_Deckler 

Hi Greg, OP has replied but not tagged you.

regards

Phil

[Greg_Deckler]

@Anonymous Seems like that would have to be a text column so just use Conditional Formatting Rules where if the text equals "TRUE", green, "FALSE", red or otherwise black?

[Anonymous]

Hey Greg, thanks for getting back to me! This may be obvious, but it's only allowing me conditionally format based on numeric values and don't know where to find the text option.