Skip to main content

Power BI

Needs Votes

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

Vote (227) Share
Noam Arnold's profile image

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)
Noam Arnold's profile image Profile Picture

philippe qtb on 14 Mar 2022 00:06:40

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?

Noam Arnold's profile image Profile Picture

Chandra Vadana Rajamohan on 18 Jan 2022 12:43:17

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.

Noam Arnold's profile image Profile Picture

CLEARIFY . on 23 Oct 2021 06:08:16

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.

Noam Arnold's profile image Profile Picture

Gary Thomann on 18 Feb 2021 01:27:36

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

Noam Arnold's profile image Profile Picture

Tim on 05 Jul 2020 23:52:20

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!

Noam Arnold's profile image Profile Picture

KRIS WILLISON on 05 Jul 2020 23:29:45

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)

Noam Arnold's profile image Profile Picture

Steven Carpenter on 05 Jul 2020 23:21:20

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.

Noam Arnold's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:45

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

Noam Arnold's profile image Profile Picture

rse on 05 Jul 2020 23:02:16

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

Noam Arnold's profile image Profile Picture

Harshad on 05 Jul 2020 23:00:51

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