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
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 >(
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
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.
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
More formatting options for measures like Negative values in brackets with red color....expecting formatting option available in Excel
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
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.