Table Help

[mahitham]

Hi,

Can any one please help me to show above 30.0% values in Green color and below 30.0% values in red in Profit Margin column in the straight table.

I have highlited the expression used in  Profit Margin column in the below image.

Please help me on this.

Thanks in advance.

[mahitham · Accepted solution]

Hi 

I have tried the conditional formatting for Profit margin like below

I need to show above 30.0% values in Green and below 30.0%values in red  but all are showing red by using below rule.

Please let me know am i missed any thing.

I am new to power BI.

Thanks in advance

[v-danhe-msft · Accepted solution]

Hi @mahitham,

Based on my research, you could use the 'conditional formatting color-by-rules' function to solve your problem, you could refer to below link:

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-rules

Regards,

Daniel He

[PattemManohar]

@mahitham Please try "Conditional Formatting" 

[mahitham · Accepted solution]

Hi 

I have tried the conditional formatting for Profit margin like below

I need to show above 30.0% values in Green and below 30.0%values in red  but all are showing red by using below rule.

Please let me know am i missed any thing.

I am new to power BI.

Thanks in advance