Adding country-based filtering to Microsoft 365 Usage Analytics

A couple of weeks ago the Microsoft 365 Usage Analytics app in Power BI was updated, as it is long overdue.

The main benefit of the “updated” app is largely a visual refresh and focuses on core workloads and services: Exchange, SharePoint, OneDrive, Skype for Business, Yammer, Microsoft Teams, and Office 365 Groups. Unfortunately none of the other apps or services are included, so organisations are still left flying blind when it comes to usage of Planner, Power Apps / Automate / BI, Sway, To Do, Whiteboard, Forms, Bookings, Stream, etc.

The Problem

A fellow MVP asked how to show country information in the dashboard (as it doesn’t show up by default) for scenarios where organisations have people located in multiple locations, so I took it upon myself to find out. Initially I thought the answer would be in exporting the underlying data and creating your own visual however that isn’t ideal – especially for people who are not fantastic with Excel (like me).

As you can see in this example for Microsoft Teams, there’s no “country” field before it starts diving into data:

The Solution

Looking at the resources page it states that the data can be sliced to show additional information such as country:

There are a few simple steps to add country data (or any other available column for that matter).

Word of caution, advice and encouragement: I am an Excel and Power BI novice, so if I can do it – you can do it.


1. Edit the report

At the top of the report page, hit the ellipsis to find the Edit button:


2. Bring up the slicers for the area you want to edit


3. Add the field you want to use

In this case we want to add the LocationCountry field under UserState, so just search for the term and select it


4. Move the column to make it more viewable

By default the additional column will be put at the end, however you can move it to wherever you like by dragging it:

5. Exit the edit view

Click on Save, then Reading view to take you back to your report:


Presto, you now have country for your filtering enjoyment!


Here’s a walk-through of the process from start to finish:



But Office 365 is just the same as on-premises functionality!

Clearly the title of this blog post is incorrect, but I had to raise it as recently someone made this comment to me. Their view was that they can run Exchange Server, SharePoint Server, and Skype for Business Server on-premises which would deliver the same functionality as Office 365.

What does Office 365 provide that you simply CANNOT deliver with on-premises systems? Focusing on the core feature set (without bringing in Project Online, Dynamics 365, EMS or others into it), it’s not a small list:

Product Description Where you see it
Exchange Online Protection Mail filtering service built into Exchange Online Behind the scenes
Advanced Threat Protection Protection against unknown malware & viruses, real-time protection against malicious URLs at time-of-click Behind the scenes
Exchange Online Archiving Yes you can have archiving on-premises, but not unlimited Client & web
Office 365 Groups Mix of document library, OneNote, Planner, Skype for Business, and SharePoint team site functionality Desktop, web & mobile
Microsoft Teams Chat-based workspace integrated with Office 365 Groups Desktop, web & mobile
OneDrive for Business Similar to Exchange Online Archiving, organisations can run OneDrive for Business on-premises but not provide unlimited storage Desktop, web & mobile
Skype Meeting Broadcast Host online meetings for up to 10,000 attendees Behind the scenes
Clutter / Focused Inbox Email sorting using machine learning, based on individual mail habits Behind the scenes
Delve Personal search & discovery of content Desktop, web & mobile
MyAnalytics (formerly Delve Analytics) Behavioural analytics based on mail & calendar Web
Yammer Enterprise social network platform Web & mobile
Office 365 Video Share & manage business videos Web & mobile
Planner Manage tasks on graphical boards (similar to Trello) Web
Sway Visual storytelling service Desktop, web & mobile
Power BI Interactive business intelligence dashboards Desktop, web & mobile
PowerApps Build mobile apps & logic flows Desktop, web & mobile
Microsoft Flow Automating workflows across apps and services (not just Office 365) Desktop, web & mobile
Office Graph Machine learning mapping connections between people & content Behind the scenes


Kirsty McGrath of OnPoint Solutions has created a wheel of the Office 365 services available, building on a similar one from Sharegate.