34 from the fields section click on the ellipsis next

34. From the FIELDS section, Click on the
ellipsis next to Date field in Sales table.
35. Select Hide . This hides Date field in
the reports view. We have the option to
view hidden fields and unhide fields as
needed.
36. Similarly hide Country, ProductID, Zip
and ZipCountry in Sales as well
37. Similarly hide ZipCountry from the
Geography table.
38. Hide ManufacturerID from
Manufacturer table.
39. Hide ProductID and ManufacturerID
from Product table.
40.
Note : It is best practice to hide fields that
are not used in reports.

Version: 12.30.2019 Copyright 2019 Microsoft 48 | P a g e
Maintained by: Microsoft Corporation
Let’s get back to our data story, Australia,
VanArsdel and 2018 – remember 😊
Let’s check if the spike occurred in a
specific region in Australia.
41. Select Revenue by Country visual.
42. From the FIELDS section, drag State
field from Geography table, below
Country in the Axis section.
43. Drag District field below State in the
Axis section.
We just created a hierarchy.
44. Make sure VanArsdel is selected in
the Manufacturer slicer
45. Enable Drill mode by selecting down
arrow on the top right corner of Revenue
by Country visual.
46. Select Australia to drill down to State
level .
47. From Revenue by Year visual select
2018 and notice Revenue by Country and
State visual.
48. From Revenue by Year visual select
2017 and notice Revenue by Country and
State visual.
49. Similarly, select 2016 . We don’t see a
spike in a specific state.
50. Select 2016 again to remove year
filter.
51. Drill up to country level.
.
.

Version: 12.30.2019 Copyright 2019 Microsoft 49 | P a g e
Maintained by: Microsoft Corporation
Let’s analyze by Product to figure out
what’s happening there. Before we start
with that let’s create a Product Hierarchy.
This way we don’t have to drag multiple
fields to the visual.
52. From the FIELDS section, click on the
ellipsis next to Category in Product table.
53. Select New Hierarchy .
Notice a new field called Category
Hierarchy is created in the Product table.
54. Double click on Category Hierarchy
and rename it to Product Hierarchy .
55. Click on the ellipsis next to Segment .
56. Select Add to Hierarchy -> Product
Hierarchy .
57. Click on the ellipsis next to Product .
58. Select Add to Hierarchy -> Product
Hierarchy .
We have created a Product Hierarchy
which is Category -> Segment -> Product.

Version: 12.30.2019 Copyright 2019 Microsoft 50 | P a g e
Maintained by: Microsoft Corporation
59. Click on the white space in the canvas.
From the VISUALIZATIONS section select
Clustered bar chart .
60. From the FIELDS section, expand
Product table.
61. Click the checkbox next to Product
Hierarchy . Notice complete hierarchy is
selected.
62. From the FIELDS section, expand
Sales table.
63. Click the checkbox next to Revenue
field.
Note : Make sure you have VanArsdel
selected in the slicer.
We see that VanArsdel has a presence in
the Urban category and a small presence
in the Rural category.