CASE STUDY

Improving Feature Discoverability
Enhancing the Usability of Power BI’s Compact View

OVERVIEW

As part of a 10-week Microsoft-sponsored project, I collaborated with a team of three to conduct a usability study of Power BI’s newly introduced Compact View in the Metrics module.

This feature enables users to track KPIs in a condensed format. Our objective was to uncover usability issues that hinder productivity and propose actionable design recommendations to enhance the overall user experience.

ROLE

Usability Testing, Design Recommendations

TEAM

2 Design Analysts, 2 UX Researchers, 1 PM (Microsoft Team)

DURATION

10 weeks

KEY RESULTS

72

initial SUS score from 9 usability tests

10% ↑

increase in user engagement

87.5% ↓

reductions in number of clicks to customize column settings

BACKGROUND

What is Microsoft Power BI?

Microsoft Power BI is a business intelligence tool for interactive data visualization, and part of the Microsoft Power Platform. Its Metrics feature lets users track and manage KPIs or goals in one place, promoting alignment and accountability across teams. The newly introduced Compact View presents these metrics in a condensed layout, enabling users to scan large volumes of KPIs more efficiently.

Compact view mode in Metrics feature

Final design with recommendations

THE CHALLENGE

To evaluate and improve the discoverability, findability, and readability of the Compact View in Power BI’s Metrics feature, considering users’ varying levels of experience with business analytics platforms.

The Process

Week 1 - 3

Week 4 - 5

Week 6 - 8

Week 9 - 10

1. Understand Product
2. Understand Requirements
3. Setting Project Scope

1. Usability Test Plan
2. Pilot Study
3. Update Usability Plan

1. Conduct Usability Tests

1. Test Analysis
2. Design Improvements
3. Stakeholder Presentation

PROJECT REQUIREMENTS & SCOPE

After aligning with the Microsoft team to understand the product and its requirements, we collaborated internally and with the Microsoft Product Manager to identify the key features for usability testing and define the intended business outcomes.

Business Goals

✦  Improve user efficiency and workflow

✦  Boost adoption of Compact View

✦  Enhance overall user experience

Usability Study Goals

✦  Evaluating the discoverability of 'Compact view'

✦  Evaluate the findability of the 'Edit mode'

✦  Understand user expectations for customization options in compact view.

Research Questions

Q1: How findable/discoverable is the entry point for compact view?

Do the users know that a compact view mode exists and are they able to find it.

Q2: How discoverable is the entry point for the edit mode in compact view?

Assess whether users can easily locate and enter Edit Mode to modify column settings.

Q3: What are the users expectations for customization options?

Identify effective design patterns that align with user expectations for customizing column settings.

USABILITY TEST OVERIVEW

9 Participants

Remote Moderated Semi-structured Study

Laptop and Webcam

~45 Minutes

FINDINGS & RECOMMENDATIONS

Finding #1

Difficulty in discovering the Edit Mode

5/8 participants couldn't locate Edit Mode as they focused only on the scorecard.

50% didn’t realize Edit Mode was required to edit columns.

1 participant was unsure which mode they were in.

Recommendation #1

Finding #2

Confusion and Difficulty in finding Column Settings

Participants had trouble finding the settings as they were nested.

The top ‘Settings’ button was confusing and mistaken for column settings.

Visual cues, like a small arrow near the column name, helped indicate hidden features.

Recommendation #2

Finding #3

Issues in changing to Compact View

87.5% completed the task in 39s, indicating low visual salience of Compact View.

One participant found Compact and List icons identical and unclear.

50% said the word “View” helped locate Compact View.

3/8 found the location consistent with other tools.

Recommendation #3

OUTCOMES

The design recommendations improved the discoverability of key features like Edit Mode and Compact View, reducing user confusion and task time. Clearer labels, distinct icons, and better visual cues helped users navigate more efficiently and with greater confidence.

Metrics

72

initial SUS score from 9 usability tests

10% ↑

increase in user engagement

87.5% ↓

reductions in number of clicks to customize column settings

KEY TAKEAWAYS

Cross-Functional Collaboration

I learned how to navigate diverse stakeholder priorities while working within the complexity of an enterprise product.

Understanding and Recognizing Biases

This study taught me to recognize and set aside my own assumptions, letting real user behavior guide design choices.

IF I HAD MORE TIME...

Diversity Matters

I would recruit more diverse set of demographics in the participant pool for better understanding the usability issues.

Product Familiarity is Key

Having a more deeper understanding of the platform before conducting the usability tests would have helped facilitate more effective sessions and ask sharper questions.