undefined

[cham]

Hi,

I created a mesure using my data set in Power BI. Measure = Price/Revenue

 I want to add conditional formating for my bar chart. I used Name and Measure for my bar chart.

I want to create conditional format as follow,

Red=<18%

Yellow=25%

Green=>30%

My data set is follow,

Name	Price	Revenue
A	200	100
B	150	50
C	400	78
D	500	45
E	300	20
F	467	90

I want to add conditional formatting as below. I want to show the shading in my bar chart as below,

[AiolosZhao · Accepted solution]

Hi @cham ,

Please try to use below setting.

Thanks.

Aiolos Zhao

[AiolosZhao · Accepted solution]

I'm also glad to help you.

Could you please mark my reply as "accepted solution", so other people will know that the topic is sovled.

Thank you.

Aiolos Zhao

[AiolosZhao · Accepted solution]

Hi @cham ,

Please try to use below setting.

Thanks.

Aiolos Zhao

[cham]

Yes it worked. Thank you so much.

[AiolosZhao · Accepted solution]

I'm also glad to help you.

Could you please mark my reply as "accepted solution", so other people will know that the topic is sovled.

Thank you.

Aiolos Zhao

[cham]

Hi @AiolosZhao 

Can you please help me to do this as well.

I have the following sheet,

Name	Status	Days
A	Good	80
B	Bad	30
A	Bad	20
A	Good	50
B	Good	20
C	Bad	90

I want to add conditional formatting for the data set above,

Good =Green

Average=Yellow

Bad=Red

as below,

Which chart i can use for this and how can i do the conditional formatting

[AiolosZhao · Accepted solution]

Hi @cham ，

Please try to use below setting:

Thanks.

Aiolos Zhao

[cham]

Thank you so much