Example

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.

Try following formatting options

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