|Task| Add a second page
Steps:
- Create a New Page
- Add the Background named Page 2 - Background Thirds.png
- Create a Slicer for Salesperson -> Name Column
- Change the Slicer to a type of Drop Down
- Create a slicer for Customer Name
- Create a Line and Stacked Column Chart, use Product -> Category for the Shared Axis, Sales -> Total Sales measure for the Column values, Sales -> Last Year Sales for the Line values and Tooltips
- Change the title of the Line and Stacked Column Chart visual to be Total Sales by Category
- Add a Line chart showing Total Sales by Year
- Rename the line chart title to be Sales by Year and Center the title
- Turn Off the Title for the X-axis and Y-Axis
- Right click on a single bar in the Total Sales by Category chart and from the Dropdown menu choose Summarize
- Create a Stacked Bar Chart using Total Sales by Subcategory
- Rename the Stacked Bar Chart title to be Ratio of Total Sales by Subcategory and Center the title
- Check the following measures for properly formatted data types
- Cost of Goods Sold -> Currency, Zero Decimals
- Last Year Sales -> Currency, Zero Decimals
- Non US Sales -> Currency, Zero Decimals
- Profit % -> Percentage, Zero Decimals
- Rolling 4 Week Average -> Currency, Zero Decimals
- Sales Bar -> General
- Selected Sales -> Percentage, Zero Decimals
- Total Profit -> Currency, Zero Decimals
- Total Sales -> Currency, Zero Decimals
- USA Sales -> Currency, Zero Decimals
- YoY Indicator -> Whole number
- YoY% -> Percent, Zero Decimals