For our Power View, we want to Click on the top of the canvas (title section) and type “Sales of Category see sales breakdown by product Over Time”. category and how it has varied Click on the upper part of the canvas underneath the title. over time. First I’ll add a title, In the ‘Power View Fields’ pane on the right, Open Products and select then create the first chart on the Category. Open Sales, and select SalesAmount. upper part of the canvas. Then, I’ll add a scatter chart that Click on the table that was created on the canvas and then select ‘Bar allows me to display multiple Chart – Clustered Bar’ from the visualization list at the top menu and resize dimensions as well as their the chart to fit the top ½ of the report. correlation based on sales amount and margin over time. Click anywhere in the bottom empty portion of the report. In the Sales dimension, select Running Total, SalesAmount, and Margin. In the Products dimension, select Category. Select ‘Other Chart – Scatter’ from the visualization list at the top menu. In the Power View Fields list, move Sales Amount to the X Value field, Running Total to the Y Value Field, and Margin to the Size field. Drag Year to the Play Axis Field. Resize the chart to fit ½ of the report. I have now created a playable Click on the maximize button on the top right corner of the chart to record of sales amounts over increase its size while it’s playing. Click the play button in the bottom left time for my three product corner of the scatter chart. categories. Notice how the current year pictured is shown in the upper right hand corner and clicking on one of the category bubbles in the plot will show a line tracking it over time while also highlighting the category in the bar chart. In a just a few steps, we have a valuable tool for gaining and sharing insights in our sales data.
For our Power View, we want to see sales breakdown by product category and how it has varied over time. First I’ll add a title, then create the first chart on the upper part of the canvas. Then, I’ll add a scatter chart that allows me to display multiple dimensions as well as their correlation based on sales amount and margin over time. Click on the top of the canvas (title section) and type “Sales of Category Over Time”. Click on the upper part of the canvas underneath the title. In the ‘Power View Fields’ pane on the right, Open Products and select Category. Open Sales, and select SalesAmount. Click on the table that was created on the canvas and then select ‘Bar Chart – Clustered Bar’ from the visualization list at the top menu and resize the chart to fit the top ½ of the report. Click anywhere in the bottom empty portion of the report. In the Sales dimension, select Running Total, SalesAmount, and Margin. In the Products dimension, select Category. Select ‘Other Chart – Scatter’ from the visualization list at the top menu. In the Power View Fields list, move Sales Amount to the X Value field, Running Total to the Y Value Field, and Margin to the Size field. Drag Year to the Play Axis Field. Resize the chart to fit ½ of the report. I have now created a playable record of sales amounts over time for my three product categories. Notice how the current year pictured is shown in the upper right hand corner and clicking on one of the category bubbles in the plot will show a line tracking it over time while also highlighting the category in the bar chart. In a just a few steps, we have a valuable tool for gaining and sharing insights in our sales data. Click on the maximize button on the top right corner of the chart to increase its size while it’s playing. Click the play button in the bottom left corner of the scatter chart.
Excel_2013_demo_track.docx