Here's a simple example to illustrate:
Load the Sales Data:
Import your sales data into Power BI.
Create the Table:
Select the Table from the "Visualizations" pane.
Add Fields:
Drag the "Subcategory" field to the "Columns" area.
Drag the "Sales" field to the "Columns" area.
Drag the "Profit" field to the "Columns" area.
Drag the "Quantity" field to the "Columns" area.
1. Apply / change background colour to sales column
Go to "Format" - Select the option "Cell elements" under "Visual" - under "Apply settings to" select "Sales" - turn on background colour
2. Apply / change Font colour of profit column
Go to "Format" - Select the option "Cell elements" under "Visual" - under "Apply settings to" select "Profit" - turn on font colour
3. Apply data bar to Quantity column
Go to "Format" - Select the option "Cell elements" under "Visual" - under "Apply settings to" select "Quantity" - turn on data bar
4. Apply icons to profit column
Go to "Format" - Select the option "Cell elements" under "Visual" - under "Apply settings to" select "Profit" - turn on icons
Tip
click on "fx" button under icon and check for various conditional formatting options