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.

Subscribe to news

Subscribe to our newsletter and be among the first ones to receive updates about latest developments, releases and other useful information that will help you get the most of our visuals.

Power BI Waterfall Charts: A Detailed Guide

Do you know how to make a waterfall chart? Here are 7 tips you should know when building user friendly Power BI waterfall charts. Customize it to tell a data story that helps you make data driven decisions.

Read More

May 12, 2022

Announcement: Microsoft Applies ZoomCharts Solutions for Latest Product

We are excited to announce the collaboration between Microsoft’s latest product Dynamics 365 Supply Chain Insights – and technologies provided by ZoomCharts the Network and Map visuals.

Read More

Mar 28, 2022

Power BI Bar Chart

It is likely that, before hearing about Power BI, almost everyone’s first encounter with a bar chart happened all the way back in pre-school. After all,...

Read More

Feb 14, 2022

How We Turned Many Excel Files Into an Interactive Power BI Report about Latvia’s Export landscape

How We Turned an Excel Sheet Into an Interactive Report: Latvia Export Barometer. ZoomCharts took part in a widescale project that created a full report of... Read More

Dec 16, 2021

Power BI Donut Chart

The donut and pie charts are some of the most ubiquitous charts around. Instantly recognizable by people who have very little to do with charts, every report... Read More

Oct 27, 2021

Improving UX with Power BI Custom Visuals

How do I make sure my Power BI reports end up getting used? The answer is – standardization. A quick Wikipedia search will tell you - standardization means... Read More

Sep 16, 2021