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 (224)

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 (20)

Comments (20)

Devis Corp on 19 Apr 2024 10:47:54

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

Good information, thanks

sehackear.top

elias zafrani on 19 Apr 2024 01:18:50

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

Thanks

Hackear Instagram

Hackear WhatsApp

Hackear Facebook

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?

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.

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.

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

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!

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)

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.

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