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 (18)
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
We already have this in Excel, why removed it from DAX/Power Pivot?
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
For advanced conditional formatting options in Power BI, try Inforiver. They have excel-like options such as classification, icons, quick rules, segmentation etc.Some videos - Data bars, Color scale, Classification, Dynamic Selection, Quick Rules and Advanced options.
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
This is helpful for accountants who want to peruse a list of numbers and quickly identify out of scope comparisons. Financial Statements still reside in the purview of a matrix with traditional columns and rows - and that means long lists of chart of accounts, and multiple columns of siloed information to compare.
RE: Conditional formatting for the font color, bars in the cell of the tables and all the other advanced options excel is offering
#,#;[Red](#,#);"-" add color to custom formula
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