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

Pedro Innecco on 05 Jul 2020 22:18:20

RE: Set Colors and Conditional Formatting in visuals

Conditional formatting is missing. Idea was implemented half-way ;)

Amanda Rivera's profile image Profile Picture

Terry on 05 Jul 2020 22:18:17

RE: Set Colors and Conditional Formatting in visuals

Dynamic Conditional Formatting is really important to our business users. Please add this function to Power BI.

Amanda Rivera's profile image Profile Picture

Garry on 05 Jul 2020 22:17:31

RE: Set Colors and Conditional Formatting in visuals

I cant see this in the desktop app?

Amanda Rivera's profile image Profile Picture

Alvaro Pasquez on 05 Jul 2020 22:17:23

RE: Set Colors and Conditional Formatting in visuals

Gauge please!

Amanda Rivera's profile image Profile Picture

Bas on 05 Jul 2020 22:16:46

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!

Amanda Rivera's profile image Profile Picture

Samy Ishak on 05 Jul 2020 22:14:14

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.

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 22:13:17

RE: Set Colors and Conditional Formatting in visuals

Need to be able to set the Colour Themes as with any other Office app

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 22:13:12

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

Amanda Rivera's profile image Profile Picture

Power BI User on 05 Jul 2020 22:13:11

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 :(

Amanda Rivera's profile image Profile Picture

Tamir on 05 Jul 2020 22:10:52

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?