Forum Discussion
Table Help
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.
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
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
3 Replies
- PattemManoharCommunity Champion
mahitham Please try "Conditional Formatting"
- mahithamHelper I
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-msftMicrosoft Employee
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