How to change the column color?

[Anonymous]

In PowerBI I try to change the column color to red when monthly sales amount doesn't reach the target and green when the target is reached. In the format of old version has data colors where you can default color, but in the new version do not have it. How can I change the colors?

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team _ kalyj

[v-yanjiang-msft]

Hi @Anonymous ,

Has your problem solved by @Anonymous 's suggestion, if you need the formula to set the colour, here's my solution.

Sales table:

Target table:

The two tables related with the month column. Create a measure:

Color =
IF ( SUM ( 'Sales'[Sales] ) >= MAX ( 'Target'[Target] ), "Green", "Red" )

In the visualization settings pane>Cell element, turn on the backgroud color and click the fx button.

Select field value and select the color measure in the dialog.

Get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Right click on the value in the Visualizations slide. Then select conditional formatting. You can adjust it based on background color or font color, etc. Once the pop up shows, select the correct formatting: gradient, field value, or rules. I find that rules is the most adjustable, you just have to fiddle with it sometimes.