Amanda Cofsky 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 (79)
- Merged Idea (2)
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.
RE: Set Colors and Conditional Formatting in visuals
Major important feature !
RE: Set Colors and Conditional Formatting in visuals
Dynamic Conditional formatting is an important feature. Is it in roadmap of PowerBI?
RE: Set Colors and Conditional Formatting in visuals
Conditional formatting is an important feature. Is it in roadmap of powerBI? Any possible timeline when it is expecting?