Power BI
Needs VotesConditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
Noam Arnold on 16 Sep 2016 20:23:47
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.
Administrator on 20 Aug 2020 01:24:22
Conditional formatting allows you to do this: https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting. You can set rules for positive, negative, color scales etc. even custom logic by using a measure that returns a hex code for your color.
- Comments (14)
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
Now we just need the Sub Totals and Totals be have conditional formatting as well!
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
I just googled all over to figure out how to format negative numbers in a table. FRUSTRATING that I needed to create another column (per field) I wanted to format this way. Had to create an INDEX for each then format the color based on the index. SAMPLE:
W2 Index = IF('Product Sales'[W2 Projected Inventory] < 0,-1,1)
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
I'm guessing this comment is pointless, but having more options around conditional formatting would be nice. Options similar to Excel would be nice. I need to do conditional formatting on text.
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
Hi,
It would be really good to be able to have conditional formatting for text too. The feature is already in Excel and a lot of other dashboard tools
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
Hi
I wish to hide the date to leave only the color of the conditional formatting (red orange green for example)
REgards
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
My vote for dynamic conditional formatting
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
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.
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
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
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
This pivot table junkie craves data bars in his matrix visualizations!
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
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.