Uncategorized

Background Concepts for Power BI

A solid layout is the foundation of every high quality report design. In this post I will show how to implement backgrounds into Power BI and provide resources to get started.

Why Backgrounds?

When thinking about Data Visualization, the primary focus is almost always on which types of visuals work best with the data in hand to tell a story. Even if a report has perfect Data and Visuals, it is the responsibility of the report author to land a cohesive story that is easy for the end user to navigate.

Margins, Distribution, Consistency, and Alignment are extremely important and often overlooked. If done poorly, these elements can take attention away from the story and leave users dissatisfied and confused. Fortunately, all four of these items can be tackled quickly and easily with a well made background.

A well made Background will:

  • Give structure and flow to a story
  • Guide and Guardrail the creative process of finding the story
  • Mask imperfection at the report level

There are many ways to build a Background for Power BI. I personally use PowerPoint for its simplicity, but more advanced graphic designers will use pro tools like Adobe Illustrator. At the end of the day, all we need to get to is a properly sized high quality image.

Avoid using shapes in Power BI to build your background

Every shape you bring into the Power BI Report directly will impact your performance, regardless if there is a query associated with it. If you bring in a single image for the background instead, you will be rendering a single element, rather than 10+ for a rich background. See the Performance Analyzer for Detail on this.

Getting Started

In the case where I do not have a story yet, I will start out in Power BI and identify an “Anchor Visual” to build my experience around. This would be the primary draw of your report page.

In this example I am looking at King County Health Inspection data and landed on a map to be my Anchor Visual. At this point, I will go into PowerPoint and start building my Background with this Anchor in Mind. I will then work with the shapes to determine a good layout for the remainder of the report.

If your Report page is 16:9 (Default) You can create in the Default Power Point slide size

Start with a shape that fits your Anchor visual and its position

The Initial shape sets the margin and spacing for the report page
Adding like-shapes and proportions across the page to fill the canvas

I will then add color that goes with my branding/theme

I will now bring this background into my PBIX:

  • In Power Point, Select All of your Elements
  • Right Click > Save as Picture
  • In Power BI Desktop, with no elements selected, open the formatting options in the Visualization pane
  • Click + Add image button under “Page Background” and find your new image
  • Remove any transparency on the slider
  • Use drop down to Choose Image Fit: Fit

I can now position the visual in the box i created for it, and start building my story based on the other boxes I laid out for it.

Perfect Fit for my Anchor Visual

If you find a key element that you want to include does not into your predetermined sections, simply modify the PPT to suit and re-load!

I really want this line chart to take this much space up but my background is not set up for it. I will then shift shapes to suit line graph while keeping my margins and spacing intact

I can also bring in our Branding and Titles to limit how many elements are rendered within Power BI

Viewing the same visuals within the report without the background you will notice that not everything is positioned well, and the report is much harder to follow.

Even here not all items are perfectly spaced, but due to the framing being aligned it is not noticeable

We now have a finished report page and can take our background and adjust our shapes to fit the needs of our remaining report pages. By keeping the same background colors/themes and redistributing our shapes we can end up with a consistent look and feel across tabs

Let me know what you think Follow on Twitter for quick tips and tricks @ChrisHamill17

Check out the Background Gallery to download the PowerPoint for this example, and check back for new Backgrounds frequently!

Uncategorized

Introduction

Hello! My name is Chris Hamill and I am a Microsoft Employee and member of the legendary Power BI CAT Team. I spent 10 years in Finance and Account jobs before finding my true passion in BI.

Alluring Analytics is my Personal Blog to share my Learnings, Tips & Tricks, and Concepts/Methods to inspire Power BI Creators to build quality experiences that resonate with End Users.

All views and opinions are mine and mine alone.