Seek color for GP% table

[Paulyeo11]

Hi All

Can some one recomend me the color scheme for below GP% table

Lo GP% mean bad and hi GP% mean good..

I feel my color scheme is no good

[Pragati11]

Hi @Paulyeo11 ,

You can apply conditional formatting on GP% value. See example below:

Then use conditional formatting option under Format options:

Click on Background Color, following window appears:

Once you click OK, you will get the following:

You can modify colours here, also you can give custom values for colours, etc.

Check the following blog for more details:

https://data-flair.training/blogs/power-bi-conditional-formatting/

Thanks,

Pragati

[Paulyeo11]

Hi Pragati

I try to re-produce your step , mine look not so nice.

[Pragati11]

Hi @Paulyeo11 ,

You can select Diverging option and give custom values to get a better color formatting:

You will end up with something like this which is better from colors point of view:

Thanks,

Pragati

[Paulyeo11]

Hi Pragati

Thank you for sharing. I like your approach , let step and more colourful. 

[PhilipTreacy]

Hi @Paulyeo11 

You could stuick with 2 basic colours, red for bad , green for good, and use shades of those to indicate how bad/good e.g.

Regards

Phil

[Anand24 · Accepted solution]

Hi @Paulyeo11 ,

You can assign red for the low values indicating danger/low values and assign green for the safe/high values.

Low Value of Range: Red: #d73027

High Value of Range: Green: #1a9850

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Paulyeo11]

Thank you very much for shaing , now look better