Learn more about SQL Server tools

 

Tutorials          DBA          Dev          BI          Career          Categories          Videos          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Events

DBA    Dev    BI    Categories

 

Power BI Focus Mode for Images and Data on Dashboards


By:   |   Read Comments (2)   |   Related Tips: More > Power BI

Problem

I heard Power BI Desktop has a focus mode? Is that for images?  What exactly does it do?  How can I better manage the visualizations in Power BI?  How can I embed my images in Power BI?

Solution

As you work with PowerBI, one of the common ways you will want to interact with PowerBI site is to drill into a chart, table, or other visualization. Microsoft added the focus functionality in one of the most recent updates which gives you a way to drill into a visualization at both the chart level and further to see the underlying data.

As I alluded to in the Problem Statement, the focus functionality does not relate to adding an image or link. Along with being able to focus on a single report, Microsoft also added the ability to added graphics, images, logos, and links to a PowerBI reports.

To get started with these functions, the first step is to download the latest edition of Power BI Desktop (PBID) from: https://powerbi.microsoft.com/en-us/downloads/. Additionally, you need to do a few things to get everything setup for access including signing up to access Power BI at http://powerbi.microsoft.com. Note that you must use a work or school address to sign up for Power BI.  Gmail, Yahoo, and similar accounts will not work.  Once you have your account setup, you are ready to start exploring the features available in Power BI including using the focus mode and adding logos and images.

Coming into Focus with Power BI

So what does focus mode really do? The focus mode takes the selected visualization, whether it is from a dashboard tile or a report visualization, and expands and enlarges it to cover the screen.  This enlargement allows a Power BI viewer to see more distinct data points and trends of course, but the added advantage is it also includes the ability to open the filter pane and adjust as needed. Such filtering is not available in the regular view. Furthermore, focus mode is not synonymous with full screen mode which is really just a full expansion of the current view to cover all areas of the current window.

To focus on a Power BI visual, you simply click the focus button, which looks like two boxes with an arrow pointing up and to the right, as shown below.  

Focus Button in Power BI

As shown in the below screen print, we now have a much larger map that covers the entire presentation area on the report or dashboard.

Focus mode in Power BI over the mid west of the USA

To remove the focus, click the Exit Focus mode button.

Exit Focus Mode in Power BI

While in focus mode, you can switch to full screen mode. Notice how full screen mode removes all the buttons and menu items.

Enter Full Screen Mode in Power BI

Full Screen Mode in Power BI

In Focus Mode Filters for Power BI

For filters you can actually interact with a page or visualization filter depending on the objects in focus. However, I find the Filter option is sort of hidden in an out of the way location. As illustrated below, the filter expand button appears on the upper right corner of the Focus Mode pane. 

Filter Expand in Power BI

Once the filter pane is open, the data points available for filtering are shown. Clicking on the data value header (for instance Business Unit, Gross Margin %, Scenario) opens the filter panel; as illustrated in the below two screen prints, you can choose either the basic method or the advanced method to use to apply the filters. The basic mode allows for the selection of available data values whereas the advanced mode allows you to customize the criteria evaluators such as "contains" or "starts with".  Each has their own benefits, but these filter modifications provide an easy way to interact with the visualization. The results of applying both these filter modes is shown in the next two illustrations. 

Apply Filter in Power BI

Advanced Filter in Power BI

You should note, though, that once you Exit Focus Mode, the filters are reset to the original values and original visualization is displayed.

Original Visual without Filters in Power BI

Pin a Visual in Power BI

Alternatively, you can apply your desired filters and actually pin the adjusted In Focus visual back to a dashboard and shown below.

Pin Visual in Power BI

Pin Visual to Dashboard in Power BI

Upon completing the pinning, the modified visualization is now part of the report or dashboard, with the selected filters applied as shown next. We could actually put this new pinned visual In Focus mode, and add or remove values (or all values) from the filter list. 

Pinned Visual Result in Power BI

See Data Functionality in Power BI

Finally, and probably one of my more favorite options is using the See Data functionality.  On reports only (not Dashboards) and when using the In Focus mode, a report viewer can quickly see the data details behind the visualization.  To see this drill down, the report viewer selects Explore > See Data.

Explore See Data functionality in Power BI

As illustrated next, the data grid displays below the In Focus visualization.

Show data result in Power BI

Using what I call the flip button, you can toggle the view between vertical and horizontal presentation. 

Toggle view between vertical and horizontal in Power BI

Adding a Tile or Image or Two

We are going to switch our "Focus" from a specific visual to adding an image or other object to your PowerBI Dashboard. The process of adding these objects falls under the Add Tile option.

Add Tile in Power BI

As shown in the below screen shot, Power BI offers us the ability to display:

  • Web Content - Using html coding and tags like iframe to display content. 
  • Image - Image must be accessed via a URL.
  • Text box - Adds a text box with text and potential to add simple links.
  • Video - Video must be accessed via a URL.
  • Streaming Data - Data is streamed through a custom API.

For the first four option, you can also add an embedded link.

Add Tile interface in Power BI

Using Add Web Content for our example, we first decide if we want to add a Title / SubTitle and then specify each as desired.  Next we need to define the content we want to display. You can of course copy this code from another source or hand code your HTML content. In the below example, we use an Iframe, but you also are able to embed full HTML coding for a page. Finally, we can decide if a custom link should be added; that option is a simple URL.  

Tile Add Details in Power BI

Following along with our above example, we now have a Tile on our dashboard that contains our requested content, the MSSQL Tips home page in this case.

Web content from MSSQLTips.com in Power BI

In a similar fashion, we can add an Image tile. Notice how we reference the URL location of the image.

Embedd Image for Tile in Power BI

Now we have a tile with our MSSQLTips image on our dashboard.

MSSQLTips Image in Power BI

We can certainly resize the tile with the image if we desire.

Resize image in Power BI

Conclusion

The Focus mode functionality within PowerBI provides a welcomed ability to zoom into a visualizations details, first by expanding the visualizations size and then if needed offering the ability explore the underlying data. Focus mode differs from full screen mode in that focus mode is only concerned with a single visual, while full screen mode displays whatever is currently displayed in full screen. Continuing with the focus theme, we can also add new tiles to a Power BI dashboard which provide the ability to add images, web content, streaming data, and text boxes.

Next Steps


Last Update:






About the author
MSSQLTips author Scott Murray Scott Murray has a passion for crafting BI Solutions with SharePoint, SSAS, OLAP and SSRS.

View all my tips


 









Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Thursday, November 03, 2016 - 7:45:30 PM - Scott Back To Top

Marco... My samples are restricted, but you can download Microsoft samples from:

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-sample-datasets/

 

thanks,

Scott


Thursday, November 03, 2016 - 5:45:02 PM - Marco Chou Back To Top

Hi Scott,

Thank you for sharing your PowerBI tips.   I enjoy it and I would like to follow each step to learn.   Where can I download the dataset?

Regards,

Marco

 


Learn more about SQL Server tools