Skip to main content

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

Andrzej Leszkiewicz on 22 Jul 2021 08:49:17

RE: Set Colors and Conditional Formatting in visuals

It's not completed. Color is one of the most important attributes in data visualization. And should be able to use conditional color formatting for data, because it's all about data visualization where data elements (lines, bars) are the most important ones. Conditional formatting have already been implemented for many secondary (important, but less than data itself) things like labels, titles, but it still doesn't work for data (lines, bars, dots in charts with a legend). Today (6+ years after this idea has been posted) we still have no full control over data colors. This should not even require any votes on the idea web site. Power BI is becoming very popular and most Power BI developers have no idea how to use colors properly. More (votes) is not better. It's not always about more, sometimes it should be about following best practices and establishing good standards. Regarding data visualization you need to seat and talk with a few professionals (Cole Nussbaumer Knaflic, Steve Wexler, Stephen Few, Jonathan Schwabish and others) instead of waiting for a new idea (because someone closed this one as complete, while it's not) to get 5000 votes.

Amanda Rivera's profile image Profile Picture

Anthony Merriwether on 05 Jul 2020 23:40:12

RE: Set Colors and Conditional Formatting in visuals

I am a Microsoft Partner and ISV and my customers and my employees are getting frustrated by the lack of attention to this obvious bug!!!! When trying to set the conditional formatting in a table visual, the formatting color changes do not work properly. How in the world do you mark this as COMPLETED? I am trying to foind the responsible party to address this bug to. This is unacceptable to mark something COMPLETE that is obviously flawed and unusable in the latest PBI release. I want this fixed now.

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:54

RE: Set Colors and Conditional Formatting in visuals

Dynamic color mapping of numerical values, which will help us set the values of colors based on the range they are present in.

Amanda Rivera's profile image Profile Picture

Tony V on 05 Jul 2020 23:22:42

RE: Set Colors and Conditional Formatting in visuals

Would also be valuable to set conditional formatting based on text field value vs having to write DAX for embedded power pi

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 23:22:23

RE: Set Colors and Conditional Formatting in visuals

I Would like to set the card font color based in a measure value.

Amanda Rivera's profile image Profile Picture

M on 05 Jul 2020 23:20:32

RE: Set Colors and Conditional Formatting in visuals

Not sure that this can be called completed. Still don't have the ability to conditionally change colors in a lot of visuals. Even text visuals cannot change. What is up people. Either reopen this or explain.

Amanda Rivera's profile image Profile Picture

Vanessa on 05 Jul 2020 22:59:16

RE: Set Colors and Conditional Formatting in visuals

There should be a way to set dynamic threshold (based on a measure value) not just hard coded values. All other BI tools have this feature by default, not sure why Power BI doesn't have this yet.

Amanda Rivera's profile image Profile Picture

JJones on 05 Jul 2020 22:57:30

RE: Set Colors and Conditional Formatting in visuals

I'm trying to do this as well. This is important!

Amanda Rivera's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 22:56:40

RE: Set Colors and Conditional Formatting in visuals

This should not be marked completed. Set threshold values to change to a specific color when a value is reached. Current formatting only supports "scales". What most of us are asking for is the ability to set any number conditional formatting rules, just like in Excel. As highest priority to me, rules to fill a certain background color or font color. Second priority would be additional formatting options such as bold, italic, underline, font size changes, etc.

Can this be escalated/reviewed as NOT COMPLETE?

Amanda Rivera's profile image Profile Picture

Peter on 05 Jul 2020 22:53:04

RE: Set Colors and Conditional Formatting in visuals

I am continually surprised by the simple features Power BI lacks. It is difficult for me to realize, that this is my problem. I should lower my expectations. I should instead be surprised when Power BI contains a simple feature, like being able to automatically color values based on another column/measure.

More and more I am just using R visualizations, which obviously allows much more control (e.g. facet for above) and has many more options. The downside is the lag when recalculating and the one way integration for controls.