100%(1)1 out of 1 people found this document helpful
This preview shows page 52 - 58 out of 140 pages.
6.From the Fieldssection, expand Datetable and click on the ellipsisnext to Month field. Select Renameand name it as MonthYear. 7.Similarly, rename the MonthNamefield to Month.
Version: 09.01.2016 Copyright 2015 Microsoft 53 |P a g e Maintained by: Microsoft CorporationSeveral of the ID columns in the tables are not useful to the end-users. Let’s hide some of the fields to present a clean user experience. 8.From Fieldssection, expand Datetable and click on the ellipsis next to MonthIDfield and select Hide. This hides the column from the report. Note: You can still see this column in the data view and relationship view. 9.Similarly Hidethe MonthNoand MonthYearcolumns from the Datetable. 10.In the Manufacturertable, HideManufacturerIDcolumn. 11.In the Producttable, Hidethe columns ManufacturerIDand ProductID. 12.In the Salestable, Hidethe columns Country, Date, ProductID, Zipand ZipCountry. 13.Select Geographytable and Hidethe column ZipCountry. 14.Select the ellipsis next to Sentimenttable and click on Hideto hide the entire table. Note: You can hide columns or tables from the report view so that your end users of the report only see the columns with which they need to interact.
Version: 09.01.2016 Copyright 2015 Microsoft 54 |P a g e Maintained by: Microsoft CorporationSimilar to your analysis of top competitors, when doing comparisons of competitors, your team is also only interested in comparing top competitors. 15.In order to apply a global filter for the entire page, click on the canvasoutside the column chart. 16.In Fieldssection, select the ellipsisnext to Manufacturercolumn in Manufacturertable and click Add Filter. This will add the Manufacturer column to Page filter. 17.In Visualizationssection, scroll to Page level filters. 18.Select the manufacturers Aliqui, Currus, Natura, Pirumand VanArsdelin the filter.
Version: 09.01.2016 Copyright 2015 Microsoft 55 |P a g e Maintained by: Microsoft Corporation19.Move the column chart visual to the right of the canvas. 20.From the Fieldssection, expand Manufacturertable and drag and drop Manufacturerto the Legendof the visual. You need the company logo in most reports. 21.Click on the white space on the canvas. 22.From the ribbon, select Home -> Image.
Version: 09.01.2016 Copyright 2015 Microsoft 56 |P a g e Maintained by: Microsoft Corporation23.Navigate to /DIAD/Datafolder and select Logo.gif. Click Open. Logo will appear on the report. 24.Resizeand Move the logo to the top left of the report.
Version: 09.01.2016 Copyright 2015 Microsoft 57 |P a g e Maintained by: Microsoft CorporationYou can see VanArsdel logo is GREEN. You want to be able to match the logo color with the color of the sales for VanArsdel in the bar chart in your report. 25.Click on the previously created Stacked column chart. From the Visualizationsection, select the format icon as shown in the figure.