Skip to main content
Microsoft Idea

Power BI

Completed

Set Colors and Conditional Formatting in visuals

Vote (570) Share
Amanda Rivera's profile image

Amanda Rivera on 04 Oct 2014 01:20:39

Power BI's visualizations have colors assigned automatically. It should be possible to set a color when a value is reached (e.g. always show negative bars in red) or for a particular color in a legend (e.g. always show Microsoft datapoints as blue)

Comments (70)
Amanda Rivera's profile image Profile Picture

Daniel on 05 Jul 2020 22:10:47

RE: Set Colors and Conditional Formatting in visuals

is it possible to set the max and min value boxes from a calculated measure?

Amanda Rivera's profile image Profile Picture

Pawel Potasinski on 05 Jul 2020 22:10:40

RE: Set Colors and Conditional Formatting in visuals

It would be great to have something simlar to Excel's conditional formatting, e.g. if a value in a column chart falls below a given minimal value then set column color to red.

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 22:10:33

RE: Set Colors and Conditional Formatting in visuals

Kindly provide this feature for line chart as well.It would be really good...

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 22:10:33

RE: Set Colors and Conditional Formatting in visuals

This feature should be available for line chart as well.

Amanda Rivera's profile image Profile Picture

Brynn on 05 Jul 2020 22:09:04

RE: Set Colors and Conditional Formatting in visuals

This is great, but it's not available for all visuals. The matrix is very limited. I'd like to be able to use conditional formatting, kpi icons, change text, etc.

Amanda Rivera's profile image Profile Picture

Kirk on 05 Jul 2020 22:08:01

RE: Set Colors and Conditional Formatting in visuals

Hi, is it possible please to be able to conditional format numbers displayed using the Card visualisation, for example if showing a negative value to be in red

Amanda Rivera's profile image Profile Picture

Jixin Jia on 05 Jul 2020 22:05:14

RE: Set Colors and Conditional Formatting in visuals

The colour conditional formatting is not enabled for table / matrix, which is a critical feature as they form great part of number based reporting / visualization needs.

Amanda Rivera's profile image Profile Picture

murty on 05 Jul 2020 22:03:53

RE: Set Colors and Conditional Formatting in visuals

it'd be great if we could set the colour based on an expression, similar to how we can with SSRS - also the ability to have indicators where you could beside the value. so that e.g. you could potentially compare the current value in the cell with a measure that has the previous 4 weeks.

Amanda Rivera's profile image Profile Picture

Dave on 05 Jul 2020 22:03:13

RE: Set Colors and Conditional Formatting in visuals

Hey Will Thompson. Is there also an option that can link a color to a legend (e.g. name/country) or what not so that the color stays the same for all future tables and graphs I create?

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 22:03:02

RE: Set Colors and Conditional Formatting in visuals

Could the colour formatting also be added to the table & matrix views in BI? I really want to apply some conditional formatting based on a RAG setup.