Conditional formatting of power bi table cell

Question

There is a product table in power bi and has a column called sales rate and it has a text value "high, medium, low" and wants to add conditional formatting to it. The background is red if it is high, yellow if it is medium otherwise green.Is there any possible way to do this?

Answer 1

Make a new column

then right-click on the visualization pane and select conditional formatting<-background color:

Format it by using field value, and you will get values you want to highlight

I recommend this Power BI course by Intellipaat to learn Power BI.