Adding country-based filtering to Microsoft 365 Usage Analytics

Office 365

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:

 

 

Track changes in Word Online

Office 365

Here’s an early Christmas present from the Office 365 team… but only for some of you. I’m not sure how they track who has been naughty or nice so I suspect this might be one of those features that is flighting to some Targeted Release users but not others.

Yesterday while co-authoring a document with Jamie LaPorte, I noticed that within Word Online (currently known as “Word on the web” – but that doesn’t really roll off the tongue) that I had the ability to enable the Track Changes feature. This is a feature that has been asked for by many users a LONG time!

The reality is that Word Online offers a far superior co-authoring experience due to the fact that everyone is working on the “live” document, as opposed to the constant synchronisation that occurs when using the Word desktop app. However the inability to track changes has been a showstopper for many who rely on that feature.

Word Online has actually had the ability to track changes for quite some time, however as outlined in this support article: “You can’t see tracked changes in Word for the web but they’re still there.”

Unfortunately this has offered little comfort to users as they still want to see the track changes effect as they work through it, otherwise they are somewhat flying blind.

What does it look like?

The first thing I noticed in the ribbon was the appearance of Track Changes:

Interestingly I appear to have a bit more control over what is tracked in Word Online:

Versus Word on the desktop (I use dark mode):

The end result is similar to what you see in Word on the desktop, where a strikethrough and colour is applied to text that has been changed, and a vertical line appears for every line in the document where a change has been made:

When will it be in my tenant?

When I posted on Twitter to ask if anyone else was aware of the Track Changes in Word Online availability, most were not aware of it and some of those that checked could not see it.

Searching around I found a post on the Word UserVoice site with commentary from a Microsoft product manager on October 2nd 2019 stating that it’s being worked on. Additionally I found a post on the Office 365 UserVoice site that unfortunately did not have any response from Microsoft.

Also searching the Microsoft 365 Roadmap there does not appear to be any reference to this functionality when searching for the term track changes, Word Online, or Word on the web. A search of the Message Center in the Microsoft 365 admin center also yielded no results.

So when will it be in your tenant? I have no idea, but if you do see it – enjoy the early Christmas present!