#WOW2025 | Week 50 | Top 1% of Customers by Profit OR Sales OR Quantity

• Dashboard Size 1000 x 650

• Create a chart with bars for Profit, Sales and Quantity by Customer Name.

• Allow the end user to sort the bars by the selected measure (Profit, Sales or Quantity)
• Display the Rank of the Customer.
• Create buttons to allow users to select each measure: Profit, Sales, Quantity
• Filter the chart, using the buttons, to show only Top 1% of Customers by either of the selected measures. For example, if Profit + Sales are selected, it would filter to show the top 1% of customers by Profit OR the Top 1 % of customers by Sales.
• Include a ‘Reset’ button, which clears the filter and shows all customers
• Color the bars by which customers fall within the top 1% for that respective measure:
  
  • Profit (top 1%: #e07a5f, others: #f7bfa6)
  • Sales (top 1%: #3d405b, others: #b8b9cb)
  • Quantity (top 1% #739f89, others: #c6d9cf)
• Create a dynamic title that shows which measures are selected and will display ‘All customers’ when the ‘Reset’ button is applied.

Extension (I did not include this as part of the challenge, because it would be asking too much, but as an idea, consider making it a more dynamic Top N% instead of a fixed 1%, or you could allow users to select Top or Bottom – ensuring that the title remains dynamic for all user selections).