|Task| Add a second page

Steps:

  1. Create a New Page
  2. Add the Background named Page 2 - Background Thirds.png
  3. Create a Slicer for Salesperson -> Name Column
  4. Change the Slicer to a type of Drop Down
  5. Create a slicer for Customer Name
  6. 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
  7. Change the title of the Line and Stacked Column Chart visual to be Total Sales by Category
  8. Add a Line chart showing Total Sales by Year
  9. Rename the line chart title to be Sales by Year and Center the title
  10. Turn Off the Title for the X-axis and Y-Axis
  11. Right click on a single bar in the Total Sales by Category chart and from the Dropdown menu choose Summarize
  12. Create a Stacked Bar Chart using Total Sales by Subcategory
  13. Rename the Stacked Bar Chart title to be Ratio of Total Sales by Subcategory and Center the title
  14. 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
Complete and Continue