formatting the percentages column

[sunil222]

I need formatting the percentages column as below

Sales   column

25.89

9.75

Please help me on this 

Requires color code for BU performance:

Meeting target - Green
within 10% - Amber
outside10% - Red

[Anonymous · Accepted solution]

Hi @sunil222 ,

The easiest way to achieve your needs is to use conditional formatting.

I have created a sample dataset, please follow my steps.

First, here is the original data set.

Second, I assume the target is 30%. Click Conditional Formatting in the drop-down box and select a font color.

Select Rule for Format Rule, and select Percent instead of Number for data type.

If 30% of the target is reached, set the color to green, if within 10% set the color to amber, if outside 10% and the target is not reached, set the color to red.

Once set up, this is what the visual will look like.

PBIX attached.

If you still do not understand anything please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Kishore_KVN]

Hello @sunil222 ,

If my understanding is right, then you are looking to have Red, Amber, Green on the basis of Column.

If I am right then create new column or measure depends on your requirement. Logic for Column is

Color Code = If(Column<=10,"Green",If(Column>10 && Column<20,"Amber","Red"))

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

[Arul]

@sunil222 ,

Could you clearly explain your data format and the expected output?