Table Visualization in Excel Power View
For whatever visualization we decide to make with Power View, we start by generating a Table, which is the default, and then quickly convert the Table to other visualizations. The Table is formatted similarly to any other data table, with columns representing fields and rows representing data values. To pick which fields to display in the Table, use the Power View Fields list to select and deselect fields. Fields from the same data table or from multiple related data tables might be used. Let’s discuss Table visualization.
Steps to Create a Table Visualization
Following are the steps to be followed in order to create a table visualization:
Step 1: Do the steps to build a Table in Power View: Select the Power View region. In the Power View Fields list, click on the table – Range. Choose from the options of Country, Events, Seasons, and Year.
Step 2: As you can see, a table with selected fields as columns and real values will be presented in Power View.
Adding a Table as Count Field
Assume you wish to show the Season Count as a column. You may achieve this by adding the Session field to the Table as Count. In the Power View Fields list, click the arrow next to the Season field. From the dropdown list, choose to Add to Table as Count.
The Table will receive a new column Count of Season, which will display the Season Count values.
Including a Count Field in a Table
When your data has more than 10000 rows, adding the field Season as Count to the Table is inefficient because Power View must do the computation every time you alter the layout of the Table. Adding a computed field to the Season data table in the Data Model is a more effective method.
Step 1: On the Ribbon, select the PowerPivot tab. In the Data Model group, choose Manage. The Data Model’s tables will be presented.
Step 2: Select the Results tab. In the Results table, in the calculation area, in the cell below the Season column, enter the DAX (Data Analysis Expressions) formula shown below:
Season Count: =COUNTA([Season])
The Season count formula is shown in the formula bar. When you Hover your mouse over a Season, then it will show the Season Count i.e.,16 in this case.
Step 3: Again, you will get a Power View notification indicating that the Data Model has been altered, and if you click OK, the changes will be reflected in your Power View. Select OK.
Step 4: You may see the following in the Power View Fields list. Season Count is a new field added to the Range table. Season Count has a calculator icon next to it, suggesting that it is a calculated field. Choose the following options: Country, Events, Season, Season Count, and Year. Your Power View Table shows the Season count by Season wise.
Power View Filtering Table
By specifying the filter criteria, you may filter the data presented in the Table. In the Filters section, select the TABLE tab.
The season should be selected. To the right of Season Count, click the Advanced filter mode icon. Choose Summer Season, then click Apply Filter. The Table will now only show summer records.
Please Login to comment...