Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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 remai...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous,

     

    Sorry, please try this.

    The measure is to apply condition format as:

    Could you provide details about your issue?

     

    Best Regards,

    Link

     

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    v-xulin-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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