Change color of negative columns

[cuongle]

How I can change the color of negative columns, let say:

Positive columns: Red.

Negative Columns: Blue.

[greggyb · Accepted solution]

Note that I have the same measure in Values and SaturationNote I have chosen my colors, set to Diverging, and put 0 as Center, with small negative and small positive values for min and max, respectively.

[cld]

How is that possible to adapt it to numers in a table such as "Conditional Number Format or Number format codes" in Excel?

I wish to have negative numbers in red and postive in black.

[Seth_C_Bauer]

@cld If you are using the table visual, the conditional formatting is not in the visual format section. It is on the field in the value section. Click on the down arrow where you would normallly choose sum, avg, do not summarize, etc. in there will be a conditional formatting option for numeric fields.

[cld]

Thanks for this first help.

I found it on the table visualisation, but i would need it on a simply "Single number card".

There i can'f find all these options. What are the possibilites?

Finally i uploaded a Custom Visual PowerBI named "Card with States by SQLBI.1.2.6" which makes what i was looking for. Still some bug on that Visual with the positioning of the value. Can't optimize the lower empty part.

Regards,