Archief op oktober 2019

Hidden Gem: Power BI mobile reports

I am not the biggest fan of Power BI dashboards. They do look amazing navigating via mobile phone and are a great way to combine insights into multiple reports from one view but in my opinion they lack certain functionality to be used as a default.

What would make Power BI dashboards great

There are some basic functionalities that would improve the usability for Power BI dashboards in a great way. I’ll briefly summarize my view on these changes.

  • Updatable pinned visuals
    You decide your new report is finished. You pin a visual to a new or existing dashboard and you add the visual to the mobile layout. In the end you notice a filter has been applied during the pin-action. This requires the visual to be pinned to the dashboard and mobile view again. And I don’t mention the resizing and renaming in the dashboard. Change in colours, labels, set slicers etc require pinned items to be re-pinned. This makes the Power BI dashboard way to solid.
  • Global slicers
    Looking at the Power BI dashboard it could be that several visuals have a different granularity in for example years that are shown. To create a single glass to interpretate the data on the same granularity it would be an amazing addition to have something like global slicers that work over reports. So a global slicer for “Year” would filter all visuals to the same period. A good starting point would be to have the Edit interaction option from Power BI desktop
  • Multi-pin in mobile view
    A mobile dashboard view can be styled in a great way by using titles and images. If you want to add images to this mobile view you need to have them in your dashboard and even if you want to use the same image, like a logo, multiple times you need to have that image in your dashboard mulitple times. An option to multi-pin the same visual would be a great addition to the mobile view but also keep the original dashboard cleaner
  • More flexilibity in dashboard layout
    The Power BI dashboard can be improved with having more flexilibity in the dashboard tile layout. Being able to change the width and height without restrictions, default settings for titles, subtitles, font etc and last but not least the ability to add content items that are not shown like images that should only be visible in the mobile view

Eventhough I see a lot of improvements I still fancy the easy and intuitive way a dashboard can be created in very little time. In my day to day job I see a lot of businesses using a default approach to Power BI content. This starts with Power BI desktop, Power BI service (report), Power BI service (dashboard) and finally sharing it with collegues. Probably this has lots to do with dashboard sharing being the only option in the beginnen for Power BI.

User navigation

In a situation where a dashboard is shared with an end-user this person can directly go to powerbi.com to navigate to the shared dashboard. After selecting a visual the user is directed to the underlying report for further analysis. This works fine and the user can get to the report fairly quickly.

If the user navigates to the dashboard via the Power BI mobile App this experience is slightly different. I really fancy this dashboard view because it has lots of space with enough room for clear visuals.

Fig 1

This dashboard view is read-only and after selecting one visual it will open to full screen. The user can see the data labels here or choose to annotate and share his thoughts (Fig 2).

Fig 2

The interactivity on this visual is limited to this visual only. If this users want’s to interact with other visuals it can navigate to the underlying report (Fig 3) by selecting the little barchart in the top right corner.

Fig 3

Eventhough phones are getting bigger and bigger still this report view is not very user friendly. Especially when there are lots of visuals and slicers on the canvas.

Power BI Phone layout

From within Power BI desktop each report page can have a mobile phone layout. This can be selected from the View tab on the ribbon.

Fig 4

By dragging & dropping items from the right panel the mobile view can be created. Yes it’s true that multi-pin should be a great addition here also!

After saving and publishing the report this mobile view can now be accessed by selecting the litle bar chart on the top right from Figure 2.

Fig 5

Now also the report is readable on mobile devices and the user is able to interact between visuals as shown in Figure 6. This improves user experience greatly and data analysis on their mobile phone.

Fig 6

Does this replace the Power BI dashboard?

The Power BI dashboard still has some great features like subscriptions, alerts and multi-report visuals but if you don’t use these this mobile view could replace the Power BI dashboard. You can also directly share a Power BI report without having to create a Power BI dashboard.

Conclusion

I see lots of organizations using the Power BI mobile app without configuring their reports for mobile consumption. It takes a little bit more time to create a mobile view for every report page but it enhances the user experience on mobile greatly!