In PowerBI:

Create a new Report.

On Page 1, create the following visualizations:

1. Table Visualization: Add the following fields and measure to the table visual: Model Year, Sold Price, Sales Tax. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show all data. Enter yes, if completed

2. Clustered Column Chart Visualization. Add the following fields to the chart: Model Year, Sold Price, Sales Tax. Format theData color: #e1c233, Theme color 7, 20% lighter. Enter yes, if completed.

3. Apply the following Advanced Filter to the Page to show data for Model Years 2000 and after. Enter yes, if completed.

Rename Page 1 your First and Last Name, for example John Brown.

What is the total Sold Price for the filtered Model Years?

What is the total Sales Tax for the filtered Model Years?