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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.