Within Power BI, there are many ways to explore your data. 

Watch the videos below to learn more about our analytics.


Drilling In

You can left click on most data points, graph legends, and grid rows to drill in to your results. 

For example, if you click on Dianne Arnold in the Mastery by Learner graph, the rest of the page will update to show her specific data. 

Image showing several graphs in Power BI, including bar charts and a map showing information by location. Some numerical stats are also shown.
When you hover over something while drilled in, you will see "highlighted" data based on what you have selected.

Using the same example above, if you hover over April's Activity History, you will see information specific to Dianne Arnold beside "Highlighted". 

Close up of information in Power BI showing details for month of April. Details include month last exercised, number of activities, number of learners, total assigned modules, percent in mastery, and date.

Filtering

On some screens, you can apply filters to hone in on specific data. 

For example, you may want to only view information for the Customer Service Module. 

Image showing several graphs in Power BI, filtered to only show data for Customer Service Module.

You can also view what filters have been applied, and edit them, by selecting one of your graphics and opening the Filters side menu. 

For example, if you select the In Mastery % graphic, and open the Filters side menu, you can see that several filters have been applied to generate this data. 

Close up of filters screen in Power BI, showing options for visual level filters, report level filters, and drillthrough. 

On some screens you can also adjust the date range to change what data is being displayed. 

Line showing date range of February 23, 2018 to May 30, 2018. 

Hovering

Hover your mouse over data in a graphic to view more details. 

For example, if you hover over the April bar in the Active History graph, you can view more details about that month. 

Close up of information in Power BI showing details for month of April. Details include month last exercised, number of activities, number of learners, total assigned modules, percent in mastery, and date.  

Right Click Options

Some areas allow you to right click and view more options. These options vary depending on the data you are selecting. 

For example, when right clicking on a data point in the In Mastery by Location map, you can drill in to the data (See Records), open a different view of the data (Show Data), include or exclude the data from the map (Include and Exclude, respectively). 

Map view in Power BI showing right click options. These include see records, show data, include, and exclude.

As another example, you can right click on a location in the Mastery by Location graph to show multiple options, including Analyze, which allows you to view additional reports generated by the system. 

Close up of chart in Power BI showing right click options. These include drill down, show next level, expand to next level, show data, include, exclude, and analyze.

Image that reads Here are the filters that cause the distribution of percent in mastery by location to change the most. Two images are also shown. The top image shows several place names, each under a bar in a chart. The second image shows the highest bars and reads Network Support with 5.4% of records, Information Security with 5.9% of records, and Resolution Support with 10.3% of records, among others, most affect the distribution.


Sorting

Within grids, you can click the column headers to sort the data in that column in either an ascending (up arrow) or descending (down arrow) order. Click the header once or twice to get the desired sorting order. 

Note: Only one column can be sorted at a time.

For example, in the Learner Mastery grid you can sort the information by average mastery in a descending order. 

Close up of learner mastery grid in Power BI showing list of learners. Beside each learner's name is the number of assignments, percent in mastery, average mastery, and average goal.

Zooming

Using the scroll on your mouse, or pinching on a mobile device, you can zoom in and out of the map .  

For example, when zooming in to the In Mastery by Location map, you can view specific locations. 

Close up of map in Power BI showing a specific location. Zoomed in to show a specific street in a city.