100%(1)1 out of 1 people found this document helpful
This preview shows page 74 - 78 out of 118 pages.
8.Click on the white space in the canvas. From the VISUALIZATIONSsection, select Slicervisual. 9.From FIELDSsection, expand Datatable. 10.Select Datefield. Notice we have a range slicer with a slider. 11.Move the slicer to filter the data to 1/1/2013 to 12/31/2017or type in the values. 12.Hoverover the date slicer. 13.Select the arrowfrom the top right corner. Notice following options are available –Before, After, List, Dropdown and Relative. Feel free to try out the various options. 14.Select Relative. Notice this has options to filter data by the Last x years, months, days or Next x years, months, days, etc. Feel free to try out various options.
Version: 04.10.2018 Copyright 2018 Microsoft 75 |P a g e Maintained by: Microsoft Corporation15.Hover over Manufacturer slicer visual. 16.On the top right corner select the arrow. 17.Select List. 18.in VISUALIZATIONSpanel select the paint roller icon. This opens the formatting options available for a visual. 19.ExpandGeneralsection, select Horizontalfrom the Orientationdropdown. 20.Select VanArsdel. 21.Notice the Slicer visual is updated. You can resizethe visual, so all the manufacturers are listed horizontally. Note: There are other options to change the Outline color, weight, etc. 22.Collapse Generalsection. 23.Note: Expand Selection Controls section. Notice there is an option to enable Select All option in the visual. There is also an option to make the slicer multi select. Feel free to explore other formatting options.It will be nice to add logos of the manufacturer to the slicer. Let’s do it.24.From FIELDSsection, expand Manufacturertable. 25.Select Logofield. 26.From the ribbon, select Modeling -> Data Category -> Image URL. Setting data category to Image URL helps Power BI to
Version: 04.10.2018 Copyright 2018 Microsoft 76 |P a g e Maintained by: Microsoft Corporationunderstand the it is a URL and it can access the data. 27.From the canvas, select Manufacturer slicer. 28.From FIELDSsection, expand Manufacturertable. 29.Drag and drop Logoto Field section. 30.Select Logofield. 31.Resizeslicer visual as needed. 32.Select VanArsdellogo to filter all the other visuals. 33.Select Revenue by Yearvisual. 34.From VISUALIZATIONSpanel, select Line and clustered column chart to change the visual type. 35.From FIELDSsection, expand Salestable. 36.Drag and drop % Growthfield to Line values. This provides a representation of the revenue and growth over time.
Version: 04.10.2018 Copyright 2018 Microsoft 77 |P a g e Maintained by: Microsoft Corporation37.Select Revenue Cardvisual. Let’s change this to a Gauge visual. 38.From VISUALIZATIONSpanel, select the Gaugevisual. 39.From FIELDSsection, expand Salestable. 40.Drag and drop PY Salesfield to Target value. 41.Resizethe visual as needed. Now we can compare Revenue with the target. It will be nice to change the colors on the visuals.