Power BI: Adidas US Sales 2020 – 2021 Power BI: Adidas US Sales 2020 – 2021


  • Download dataset 




  • Load data into power bi desktop 

  • Select transform data from the home tab and the below should open




  • Transform the data as shown below (remove null and use first row as headers)
  • Add a new column and type the DAX formula in the formula bar





  •  Click on New Source button, and select Blank query from the list and click on Connect,
 Under properties in the Name box type in 'Refresh Date'
 On the DAX formula bar type ' =DateTime.LocalNow()'
             Click on Convert to Table button
             Click on Close & apply button and save


  • Make a relationship between the two tables 
  • Enter all the DAX formulas for the measures 




  • Add the logo
  • Add the remaining logos and position them as shown below

  • Add date slicer





  • Add the KPI cards

  • Add the sub KPI
  • Add Indicators
  • Add refreshed Date




  • Create mth/qr/yr chart
  • Create Product Chart
  • Create the sales method chart


  • Create a location map and legend 
  • Final 




Click here for the interactive dashboard!