Grid System applied to report design in Power BI
Updated: May 14
In this post, we will cover the basic concept of a grid system that allows us to understand the value of this tool and the usefulness of these design principles, we will also explore the options available in Power BI to adopt it and apply this framework, and a quick start to build a Grid system to our report.
What is a Grid System?
A Grid System is a two-dimensional structure composed of a series of horizontal and vertical axes that form intersections between axes, resulting in a structure that allows you to position, align, contain and organize any visual element in a compositional layout.
The following image shows the anatomy of any Grid System with its basic components and the resulting basic structures.
Margins are the negative space provided to delimit an area where we can integrate different communication elements to define a page layout and focus attention on the visual and narrative content. (Want to know more about whitespace? Dashboard design basics - whitespace )
Flow-lines are horizontal alignments in a grid system that assist in organizing visual elements and negative space.
Modules are individual units that, when repeated and separated by a proportional spacing, create the grid system, and when combined, they create columns and rows.
Spatial zones are grouped modules that form containers to display related information elements.
Columns are containers with vertical alignment that hold visual and narrative content and create vertical divisions, and there can be any number of columns in a grid system.
Markers help readers to navigate the document; these include page numbers, headers, footers, and icons.
A gutter is a vertical space located between columns.
The first basic structures of single, double, and multiple columns are not considered for our design purposes. Their application may be limited, so we will focus on the last three more suitable structures to the complexity and amount of elements that we integrate into a report.
It is an arrangement of alignments and zones that allows the organizing and display of visual elements in order of importance.
A modular grid is composed of vertical and horizontal alignments which arrange the structure into smaller chunks of space, creating modules, usually squares, that are used to contain, organize and display complex information.
Composite grids are formed by integrating or nesting two or more grid systems into an organized and systematic structure, which allows for more variation in the layout design.
Grid System in Power BI Context
Grid systems originated to serve as a guide, tool, and framework for printed products; as such, the Grid system has evolved, and its use has gone beyond this context and has been used in designing digital products, specifically in web design, it's a tool that has proven its efficiency over time and in different media, so it is necessary to take this framework for designing reports to organize and present complex and multifaceted information systematically and aesthetically.
Many requirements drive every report we design, so we must make a specific approach to the Grid system we will use for each case; we can't start dropping visual objects on the page; there must be a purpose for each graphical object that requires our report, and each visual will have a specific place prioritizing the information that needs to be displayed, and this is where our grid system comes into the scene.
Each design problem requires a different approach and application of the grid system.
The use of a simple grid understood as just the intersection of lines is not enough to achieve an adequate layout and composition for our report; it is necessary to go further and incorporate the principles and framework of the Grid system to start an effective design, which allows us to organize, hierarchical and facilitate the consumption of information in our report.
Power BI has Gridlines in the Pane View > Page options > Gridlines; it's the essential reference that you could have and use as an auxiliary design tool; it is just a simple intersection of axes that form modules of 96px*96px; however, it's simplicity does not demerit its usefulness, because it has intelligent guides, these work fine when selecting a single object, but in the case of having several selected elements, it's necessary to group them to have the auxiliary alignment provided by the guides, once placed the first element we can go organizing and integrating more features into your report.
Another available option is on the Pane View > Page options > Snap to grid, whit this option, you can move all your elements according to the modules of the grid, but its use can be a bit tricky because any part is resized to the closest axis to which it is located just by moving it.
Quick Start for building a Grid System
To start building a proper grid system for our report, we must consider several factors, some of which we can list: The canvas dimension, the type of report (pane, analytical, operational), how many pages our report will have, what metrics we will use, which and how many visual objects we consider using, what type of navigation we will use, as well as other factors that we can go into in more detail in future posts.
For now, we can start with a test to build the page layout of our report, using as a reference the position of the first module that shows the Gridlines option; we need to understand a little the layout and dimensions of the grid that Power BI offers us to integrate the elements of a grid system in our composition.
We begin placing the first element in the module that is formed in the intersection of the second row with the second column of the grid; considering that we need to integrate the essential elements of a grid (Margin, Flowlines, Gutter, etc...); we size our first module of 88px*88px leaving 8px space between each module, doing this way we take advantage of the 96px per module that has the Gridlines by default, and we get 16px between each module; which is just the jump space between objects that Power BI uses when the "Snap to grid" option is enabled without the limitations of movement and without the inconvenience of resizing the objects to the dimensions of the grid; a way to achieve this 16px space jump without enabling this option is to hold down the shift key while moving our element with the arrow keys; once the first element is located, we can start building our modular grid system from this one.
The following image shows a 2*2 grid with the dimensions per module and spacing just described.