Powerviz
  • Introduction
  • Installation Guide
    • Install from Appsource
    • Import through file
    • Adding the Powerviz visuals as Organization visuals
  • Date Picker
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Calendar
      • Formatting
      • Date Picker Button
      • Default Selection
      • Date Selector
      • Presets
      • Selection Controls
      • Date Range
      • Invalid Dates
      • Weekends/Holidays
    • Themes
      • Default Theme
      • Custom Theme
  • Sunburst
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Chart Options
      • Data Colors
      • Fill Patterns
      • Arc Settings
      • Labels
      • Sorting
      • Ranking
      • Center Circle
      • Leaf Label Images
      • Conditional Formatting
      • Show Condition
      • Annotations
      • Grid View
    • FAQ
  • KPI
    • Introduction
    • Get Started
    • Format Pane
    • Edit Mode - Introduction
      • KPI Charts
        • Advanced Text
        • Bar Chart
        • Lollipop Chart
        • Line Chart
        • Area Chart
        • Combo Chart
        • Donut Chart
        • Pie Chart
        • Linear Gauge
        • Liquid Gauge
        • Radial Gauge
        • Bullet Chart
        • Waterfall Chart
        • Icon
        • Image
        • Shape
      • Templates
      • Small Multiples
      • Actions
      • Import/Export
  • Activity Gauge
    • Introduction
    • Get Started
    • Format Pane
    • Advance settings: Introduction
      • Gauge Options
      • Target
      • Data Colors
      • Fill Patterns
      • Labels
      • Ranking
      • Sorting
      • Center Circle
      • Mouse Over Text
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Annotations
  • Funnel Chart
    • Introduction
  • Horizon Chart
    • Introduction
  • Ridgeline Plot
    • Introduction
  • Rose/ Donut/Pie Chart
    • Introduction
  • Word Cloud
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Word Options
      • Data Colors
      • Shapes
      • Text Style
      • Direction
      • Ranking
      • Exclude
      • Conditional Formatting
      • Show Condition
      • Grid View
      • Lasso and Reverse Lasso
  • Linear Gauge
    • Introduction
  • Filter
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings - Introduction
      • Filter Settings
      • Cell Style
      • Cell Colors
      • Title Bar
      • Column Headers
      • Image Styling
      • Default Selection
      • Conditional Formatting
      • Import/Export
      • Templates
  • Lollipop Chart
    • Introduction
  • Heatmap
    • Introduction
    • Get Started
    • Format Pane
    • Advanced Settings: Introduction
      • Shapes
      • Data Colors
      • Data Labels
      • Axis Settings
      • Grid Lines
      • Sorting
      • Plot Area
      • Reference Lines
      • Ranking
      • Totals
      • Small Multiples
      • Conditional Formatting
      • Show Condition
      • Grid view
      • Lasso and Reverse Lasso
  • Network Graph
    • Introduction
  • Sankey Chart
    • Introduction
Powered by GitBook
On this page
  1. Heatmap
  2. Advanced Settings: Introduction

Grid view

PreviousShow ConditionNextLasso and Reverse Lasso

Last updated 8 months ago

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 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

Search bar

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

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 allows you to take columns and create new table layouts from them. It helps in analyzing trends and patterns. By default, pivot mode is enabled in the heatmap. In this view, the category is in a 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.

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 the 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.

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

Use this button to go back to the visual view.

ATTENTION

Grid view is for reading purposes 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 Heatmap visual, and it should not be treated as an independent visualization.

Filter panel

Pivot mode

Column option

Page navigation

Dark/light mode

Back button

​
​
​
​
​
​