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

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering

The conditional formatting implemted is good but i miss the option to format the font red for negative numbers and blue for positiv numbers. Please add conditional formatting for the font color, bars in the cells and all the other advanced options excel is offering.
Status: Needs Votes
Comments
pchapple1
New Member
As with most accounting software systems, auto-change the color of text/cells to show negative values when viewing a Table visual. This could be a selectable asset in the attributes of a visual.
sathish_gurrala
New Member
More formatting options for measures like Negative values in brackets with red color....expecting formatting option available in Excel
Bjuu
Advocate II
It would be great when i can set the colors for positive Values in green and automatically invert this color for negative values to red. Generally in Bar-Charts. This Function would be similiar to the "Invert Filling when negative"-Checkbox in Excel. Bonus: I can choose, if negative is good or bad. Sales would be bad, Costs would be good.
V-61ROSA
New Member
Specially for those cases when I need to classify different metrics to evaluate and every one has a specific Target. For instance I try to configure Conditional formatting into a scorecard with different metrics and it is not possible using BI once I can not use range of specific value to do it >(
jason69
New Member
Color is so important in visualization. Being able to color by value is critical for red-yellow-green visuals and visuals with negative-positive values. It's great that you added color saturation, but that does not help with the color value itself, especially in the case of negative numbers. Also, please make sure that the color formatting allows for specific colors as well as diverging colors. An added bonus would be to allow for stepped gradients and not only continuous gradients. Thanks.
jgcronin
New Member
This pivot table junkie craves data bars in his matrix visualizations!
jayson_chabot
New Member
Helpful for looking a data (in a Matrix/Table) that is similar in size and scale In Excel, I go to ... Home Tab (with a Pivot Table cell selected) (Click on) Conditional Formatting >> (select) Data Bars >> (specify) Gradient Fill
mpesham
New Member
I have a table with multiple metrics in it and need to be able to configure the "good" and the "bad values (which are not uniform) for each column/metric separately. A simple example would be returns. I would like to be able to configure the text for the % of returned sales to 0 is gray, 0.1 to 1% is yellow, 1.1 to 2% is red. This should be configurable by metric with user defined values. The existing "low is good" or "high is good" thing does not work across a wide range of use cases.
harshadp
New Member
My vote for dynamic conditional formatting
rseiesava
New Member
Hi I wish to hide the date to leave only the color of the conditional formatting (red orange green for example) REgards