Question 1 In Power BI: 1. Create a new measure named Sales Tax by using the app
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
Question 1
In Power BI:
1. Create a new measure named Sales Tax by using the appropriate Expression to multiply the Sold Price from the Inventory table by the State Tax from the related Location table. Format Sales Tax as a whole number, 0 decimal. Enter yes, if completed
Question 2
In Power BI:
1. Create a new measure named Gain/Loss by using the appropriate Expression to subtract the SUM of the Sold Price from the SUM of the List Price. Format Gain/Loss as a whole number, 0 decimal.
Question 3
In Power BI:
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.
2. Clustered Column Chart Visualization. Add the following fields to the chart: Model Year, Sold Price, Sales Tax. Format the Data color: #e1c233, Theme color 7, 20% lighter.
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 Naima.
What is the total Sold Price for the filtered Model Years?
What is the total Sales Tax for the filtered Model Years?
Question 4
In Power BI:
Add a new Page to the Report.
On Page 2, create the following visualizations:
1. Table Visualization: Add the following fields and measure to the table visual: Location ID, 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.
2. Pie Chart Visualization. Add the following fields to the chart: Location ID, Sold Price. Format the larger slice of the Pie Data color: #e1c233, Theme color 7, 20% lighter.
3. Apply the following Filter to the Page to show data for Location ID: LOC04 and LOC05.
What is the total Sold Price for the filtered Location ID?
What is the total Sales Tax for the filtered Location ID?
What % of the Pie chart is the larger slice?
Question 5
In Power BI:
Add a new Page to the Report.
On Page 3, add the following visualizations:
1. Table Visualization: Add the following fields and measure to the table visual: State, Sold Price, Gain/Loss. Format the Table Visual: Font: Segoe, Size of Data Values: 15 pt, Column Headers: 14 pt. Adjust columns as required to show all data.
Click on the Latitude field in the Location table. On the Column Tool ribbon change the Data Category from Uncategorized to Latitude.
Click on the Longitude field in the Location table. On the Column Tool ribbon change the Data Category from Uncategorized to Longitude.
2. Map Visualization. Add the Latitude and Longitude fields to the Latitude and Longitude boxes in the Location field on Visualizations Pane.
3. Add the Sold Price field to the Size box in the Location field on the Visualizations Pane. Format the Bubble Size to 10 and Data color #ad5129 Theme color 3 25% darker.
Select the State of California (CA) and Colorado (CO), so that only these States show up on the map (adjust the zoom to show the States with less details). What is the combined total Sold Price for the 2 states?
