Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
cuongle
Advocate II
Advocate II

Change color of negative columns

 

 

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

 

Positive columns: Red.

Negative Columns: Blue.

 

 

Capture.PNG

1 ACCEPTED SOLUTION
greggyb
Resident Rockstar
Resident Rockstar

Note that I have the same measure in Values and SaturationNote 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.Note 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.

View solution in original post

4 REPLIES 4
greggyb
Resident Rockstar
Resident Rockstar

Note that I have the same measure in Values and SaturationNote 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.Note 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
Frequent Visitor

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
Community Champion
Community Champion

@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.

condform.JPG


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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.

Man Frustrated

Capture.PNG

 

Regards,

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.