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

[Noam]

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.

[mariana_pederiv]

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

[stcarpenter]

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.

[KRIS_WILLISON_K]

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)

[fbcideas_migusr]

Now we just need the Sub Totals and Totals be have conditional formatting as well!

[nishalit]

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.

[gary_thomann]

#,#;[Red](#,#);"-" add color to custom formula

[admin49]

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.

[chandravr]

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.

[qtbphilippe]

We already have this in Excel, why removed it from DAX/Power Pivot?