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
Gauge please!
RE: Set Colors and Conditional Formatting in visuals
I've created a new idea (here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12432660-dynamic-conditional-formatting-in-visuals-based-on) containing dynamic conditional formatting based on data (and not hard coded manual input). So people who agree that the above solution is not complete please help by voting!
RE: Set Colors and Conditional Formatting in visuals
Would be great to be able to host some sort of company leaderboard on dashboards!
RE: Set Colors and Conditional Formatting in visuals
Hi there,
I don't think the OP's idea has actually been implemented. The OP suggests "set a color when a value is reached," which implies being able to map the results of aggregated measures to different colors. In the link provided (https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tips-and-tricks-for-color-formatting/#customize-the-colors-used-in-the-color-scale), there is a work around using the minimum and maximum values, but this only facilitates two colors - what I interpret the OP's concept of 'Condition Formatting' is that several different colors based on several thresholds.
RE: Set Colors and Conditional Formatting in visuals
Need to be able to set the Colour Themes as with any other Office app
RE: Set Colors and Conditional Formatting in visuals
There is no option to change the color in a Gauge visual based on the value of your measure
RE: Set Colors and Conditional Formatting in visuals
I'm not seeing where to set the THeme colors (in order to set it to our company standards).. Also it doesn't seem that I can set individual colours manually via RBG values... need to know the hex code too :(
RE: Set Colors and Conditional Formatting in visuals
Hi.
I can't seem to have diverging colors in my bar chart.
When i press the color data i can only assign colors to specific bars.
Is there a reason?
What can i do?
RE: Set Colors and Conditional Formatting in visuals
is it possible to set the max and min value boxes from a calculated measure?
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.