Sales overview by product and sales representatives: sample report

Feb 26, 2020

Get inspired! Take a look at this sample report and find new ideas for sprucing up your own sales reports in Power BI. Check out interactions, chart combinations and cross-chart filtering.


Try these interactions:

On the Sales Overview page

  1. Click on one of the two donut charts to filter the report by either seller or product line. Click on the center of the donut to go back.
  2. Click on the "Others" slice to see the rest of categories. Click "Previous" slice to go back.
  3. Click on one of the columns in "Total sales vs Budget" chart. It will filter report and drill down to a smaller time unit.
  4. Click and drag on the x-axis of "Total sales vs Budget" chart" to highlight a certain time period and filter report based on the selection.

On the Sales Team page

  1. Click on the image of one of the sales representatives.
  2. Click on one column in the column chart to filter results by product category.
  3. Clear filters.
  4. Right click on one of the columns in the " Sales by Product Line" chart. Slect Drill-through --> Deal overview to open detailed tabular view of the deals.

On the Product page

  1. Click on the columns in the column chart to drill into next level of data.
  2. Click on the area chart to drill down to a smaller time unit.
  3. Click "clear filters" afterwards
  4. Click and drag on the x-axis of the area chart to to highlight a certain period and filter the results based on the selection.

Noticed something you would like to include in your reports? See a room for improvements? Share it in the comment section!

Want to build such interactive reports yourself?
Sign up to our webinars, where our friendly product specialist Aivis Pavlovs will share the essentials, tips&tricks and best practices.

Comments