Conditional Formatting not working for one row table

[Trebor]

Hi All,

I'm looking to conditionally format values in a table that only has one row. The formatting rules that I have created do not appear to work unless there are multiple rows in the table. 

Any ideas on how to get this working?

Thanks.

[v-yuta-msft · Accepted solution]

@Trebor ,

The conditional format can work well on one row table. You may have drag the aggregation value of columns to the value field of chart. Click the column in Field and select "Don't summarize" instead of "Sum".

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.