This post dhows can how to put color on single row of data in a table.
When you see the below dashboard there is a table with Item and Score. The Score with green and red color. Somehow this will not happen if you have only one row of data.
I found a workaround, it may not be a proper way.
Click on the table with one row. Choose Edit Queries.
You will see the Data Type of the 3 column is Decimal Number.
Click the Cross to delete the Changed Type step.
The Data Type now is Any. Click Close abd Apply.
Now go to Format.
Choose Conditional Formatting. On the Font color… Click Advanced controls,
Click OK after you select a color.