Conditional Formatting in Tables

[Anonymous]

Hi guys,

I've been having some troubles getting conditional formatting to work in PowerBI.

I'm trying to get the Icon (the circle in the table below) to change colors based on a value in the table. the circle is generated by Icon = unichar(xxxx)

The conditional formatting settings below:

The data for the specific row it should read (which has a value of 1) and should change the circle color to red..

However my end result is in a black circle in the 1st picture.

Is there any thoughts? I previously replicated this exercise last month (on an earlier ver of PBI) and got it to work. I've made some minor changes but have not been able to replicate it now..

Thanks for your help!

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

Based on this document, Any Table that does not have a grouping is displayed as a single row that doesn't support conditional formatting. 

We can create a Enter Table with only one row and one column, enter the value as one space or any text you want, put it into the table visual, set as Don't Summarize to archieve your requirement.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.