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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

@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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors