Skip to main content

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 on the top right corner of the screen.

Anatomy​

When you type in search box, the grid view filters out the categories right away. It makes it easier to find the values you want.

Filter panel​

The filter panel can be used to change the filter state. Here you’ll also get a search box to search across all field cards. 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 layout from them. It helps in analyzing trends and patterns. By default, pivot mode is enabled in Sunburst. In this view the category is in hierarchy with collapsed mode.

To convert the hierarchy view into a tabular view:

Disable the Pivot Mode > remove all the columns from Row Groups > you’ve got a simple table.

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​

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​

Change between dark and light mode based on individual preference for better accessibility. User can also switch them into reading mode.

Back button​

Use this button to go back to the visual view.

attention

Grid view is for reading purpose only. Any modifications made in this mode will not be saved and will return to the default state upon page refresh. Its primary function is to enhance the comprehension of the Sunburst visual, and it should not be treated as an independent visualization.