Grid View

Grid view is an interactive table in Power BI that provides a quick overview of data. The modifications made in this view will not affect the visual or actual data. The grid view changes remain only for that session and then revert back to the default state.

You can easily enable the grid view by clicking on the table icon in the top left corner of the screen.

Search input instantly filters out the categories in the table view. It helps in easily locating the specific values.

Filter panel

The filter panel can be used to search for and limit certain values. Here you’ll also get a search box to search the field names. For text columns, you can use a checkbox to select categories, and for numeric columns, you can filter values by less than or greater than conditions.

Pivot mode

Pivot mode allows you to take columns and create new table structures from them. It helps in analyzing trends and patterns. By default, pivot mode is enabled in Word Cloud.

Column option

By hovering your mouse over the column headers, you can see the column options. Click the menu icon to open the settings. You get the following options:

  • Option to pin a column.

  • Change the width of selected or all columns.

  • Expand/collapse option.

  • Reset to default.

You can also access the column-specific filter panel from here.

Page navigation helps divide the single list into multiple pages. To switch pages, use the left and right arrows at the bottom.

Dark/light mode

The grid view has dark and light modes for better navigation and usability. The user can also switch them into reading mode if they want to.

Back button

Use this button to go back to the visual view.

Last updated