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)
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.
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.
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.
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
RE: Set Colors and Conditional Formatting in visuals
I Would like to set the card font color based in a measure value.
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.
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.
RE: Set Colors and Conditional Formatting in visuals
I'm trying to do this as well. This is important!
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?
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.