ExamFinch.com My Study

Study guide

8.2 Sorting, Selection Pane, Mobile Layout, and Accessibility

Practice this exam

Microsoft Power BI Data Analyst PL-300

Track your progress as you read

Finished sections get a check mark.

1 Introduction

About the PL-300 Exam The Power BI Ecosystem

2 Chapter 1: Get or Connect to Data

1.1 Data Source Types and Connections 1.2 Storage Modes: Import, DirectQuery, and Direct Lake 1.3 Data Source Settings and Parameters

3 Chapter 2: Profile and Clean the Data

2.1 Data Profiling in Power Query 2.2 Resolving Errors, Nulls, and Data Quality Issues 2.3 Data Types and Type Detection

4 Chapter 3: Transform and Load the Data

3.1 Column Transformations and Data Types 3.2 Grouping, Aggregating, Pivoting, and Unpivoting 3.3 Merge Queries, Append Queries, and Relationship Keys 3.4 Query Folding and Load Performance

5 Chapter 4: Design and Implement a Data Model

4.1 Star Schema Design 4.2 Relationships, Cardinality, and Cross-Filter Direction 4.3 Table and Column Properties 4.4 Calculated Columns and Calculated Tables

6 Chapter 5: Create Model Calculations with DAX

5.1 DAX Fundamentals and Measures 5.2 The CALCULATE Function 5.3 Time Intelligence Measures 5.4 Statistical Functions, Semi-Additive Measures, and Calculation Groups 5.5 Essential DAX Patterns and Functions Reference

7 Chapter 6: Optimize Model Performance

6.1 Performance Analyzer and DAX Query View 6.2 Model Size Reduction and Cardinality Management 6.3 DAX Optimization Patterns

8 Chapter 7: Create Reports

7.1 Visual Types and Selection 7.2 Visual Formatting and Conditional Formatting 7.3 Copilot in Power BI Reports 7.4 Report Page Configuration and Slicers

9 Chapter 8: Enhance Reports for Usability and Storytelling

8.1 Bookmarks, Navigation, and Drillthrough 8.2 Sorting, Selection Pane, Mobile Layout, and Accessibility 8.3 Export Settings and Automatic Page Refresh

10 Chapter 9: Identify Patterns and Trends

9.1 The Analyze Feature and AI Visuals 9.2 Using Copilot to Summarize the Semantic Model 9.3 Advanced Analytics Patterns

11 Chapter 10: Create and Manage Workspaces and Assets

10.1 Workspaces, Apps, and Content Distribution 10.2 Subscriptions, Alerts, and Semantic Model Refresh 10.3 Dashboards and Advanced Distribution

12 Chapter 11: Secure and Govern Power BI Items

11.1 Row-Level Security (RLS) 11.2 Sensitivity Labels, Item Access, and Governance 11.3 Deployment Pipelines and Content Lifecycle

8.2 Sorting, Selection Pane, Mobile Layout, and Accessibility

Key Takeaways Explain This Topic AI

Sort visuals via More options -> Sort axis or column headers; sort by a hidden field, and use model-level Sort by Column to fix month ordering.

The Selection pane manages z-order (layering), show/hide, visual grouping, renaming, and tab order for keyboard navigation.

Mobile layout (View -> Mobile layout) is a separate portrait arrangement of the same visuals; without one the phone app just scales the desktop page.

Accessibility requires alt text on every meaningful visual, a logical tab order, sufficient contrast, and not relying on color alone; alt text can be dynamic via a measure.

Personalize visuals lets consumers temporarily change visual type, fields, and aggregation and save personal bookmarks - changes are per-user and never affect others.

Last updated: June 2026

Quick Answer: Sort a visual from its More options (...) -> Sort axis menu, or click a table/matrix column header. The Selection pane (View tab) manages visual z-order (layering) , show/hide , tab order , and grouping . Mobile layout (View -> Mobile layout) is a separate portrait arrangement of the same visuals. Alt text on every meaningful visual plus a logical tab order are the core accessibility requirements. Personalize visuals lets consumers temporarily restyle visuals without edit rights.

  • Sorting visuals
  • Basic and cross-field sorting

Click More options (...) -> Sort axis -> [field] -> Sort ascending/descending . For tables and matrices, click a column header to toggle direction. You can also sort by a field that is not displayed : add it to the visual's wells, sort by it, then remove it from view — useful when the display label is text but you want to sort by an underlying numeric or date key.

A related modeling technique is Sort by Column (Column tools -> Sort by column), which fixes the order of a categorical column model-wide — the canonical example is sorting a Month Name column by a Month Number column so charts read Jan, Feb, Mar instead of alphabetically.

Top N filtering

In the Filters pane , set a visual-level filter's Filter type = Top N , choose Top or Bottom , enter N, and drag a measure into By value . Example: Top 10 Products by Revenue. Top N is evaluated in the current filter context, so a region slicer changes which 10 products appear.

Selection pane

Open View tab -> Selection . It is the control center for layered and accessible pages.

  • Feature What it does
  • Visibility (eye icon) Show/hide a visual without deleting it — the backbone of bookmark toggles
  • Layer order (arrows) Sets z-order so the right visual sits in front when visuals overlap
  • Tab order Sets the keyboard navigation sequence for screen-reader users
  • Rename Gives visuals meaningful names that screen readers announce
  • Group Bundles related visuals to move, resize, or show/hide as one unit

Tab order is the accessibility half of this pane: switch to the Tab order tab, drag visuals into a logical reading sequence, and remove decorative visuals from the order so keyboard users aren't forced to tab through them.

Mobile layout

View -> Mobile layout opens a phone-shaped portrait canvas. You drag the existing desktop visuals onto it and arrange them independently — you are not creating new visuals, just a second layout of the same ones. Best practices: lead with KPI cards, show fewer visuals than the desktop page, use finger-friendly slicers and buttons, avoid wide many-column tables, and verify in the Power BI Mobile app. If you add no mobile layout, the phone app simply scales the desktop page, which is usually unreadable.

Accessibility

Power BI reports must work for keyboard and screen-reader users. The core requirements:

  • Requirement Implementation
  • Alt text Describe what each visual shows and its key insight
  • Tab order Logical keyboard sequence (Selection pane)
  • Color contrast Sufficient text/background contrast (4.5:1 for normal text)
  • Don't rely on color alone Add labels, markers, or patterns
  • Keyboard navigation Every interactive element reachable by keyboard
  • Meaningful names Rename visuals so screen readers announce them

Good alt text: "Bar chart of 2026 quarterly revenue. Q1 $2.4M, Q2 $3.1M, Q3 $2.8M, Q4 $3.5M; up 46% from Q1 to Q4." Bad: "Chart". Alt text can be dynamic by binding it to a measure (conditional formatting -> Alt text -> fx), so it updates with filter context: Revenue Alt Text =

  • "Revenue chart showing " & FORMAT(SUM(Sales[Amount]), "$#,##0") &
  • " total for " & SELECTEDVALUE('Date'[Year], "all years")

Power BI also ships a built-in high-contrast detection that picks up Windows high-contrast mode, and supports full keyboard shortcuts (Ctrl+arrow to move focus, Tab to enter a visual).

Report personalization

Enable File -> Options -> Current file -> Report settings -> "Personalize visuals" . Consumers then see a personalize icon and can temporarily change the visual type , add/remove fields , change aggregation , and re-sort — then save the result as a personal bookmark . Changes are per-user and temporary; they never alter the published report for anyone else. Authors can allow or block personalization per visual.

Grouping and the show/hide toggle pattern

The Selection pane's Group and Visibility features combine into the most common interactivity pattern on the exam. Suppose you want a single page that toggles between a chart view and a table view. Place the chart and table on top of each other, group each one (so future visuals you add to a view move with it), then in the Selection pane hide the table and create a bookmark "Chart view"; hide the chart, show the table, create "Table view"; finally add two buttons mapped to those bookmarks. The Selection pane is what makes the hidden visual reappear cleanly — deleting and re-adding visuals would lose their formatting.

Accessibility: the full checklist Microsoft tests

Power BI's accessibility guidance (which the PL-300 draws from) covers more than alt text. Themes : ship a high-contrast-friendly theme and avoid color combinations that fail for color-blind users (red/green together). Markers : in line and scatter charts, turn on markers so series are distinguishable without color. Tab order : set it deliberately so a screen-reader user hears KPIs first, then detail. Title and labels : every visual needs a clear title; rely on data labels rather than only a legend. Tooltips : keyboard users can open them, so keep them informative.

Built-in checks : the report's Show table / keyboard accessible data view (Alt+Shift+F11) exposes a visual's data as a navigable table for screen readers. None of this requires Premium — accessibility is a Desktop authoring discipline.

Personalization vs. editing — the boundary

A frequent distractor pairs personalization with model editing. Personalize visuals never touches the data model : a consumer can swap a bar chart for a line chart and add a field that already exists in the model, but they cannot add new measures, change relationships, or alter source data. Their changes are stored as a personal bookmark scoped to them; other users and the published report are unaffected. Contrast this with a Contributor/Member opening the report in edit mode, whose changes do alter the shared report. Authors enable personalization per report (Report settings) and can disable it for specific visuals.

On the exam

Expect questions that map a goal to the Selection pane (overlapping visuals -> layer order; keyboard order -> tab order; show/hide -> visibility + bookmarks), require alt text + tab order + markers for screen-reader accessibility, ask what personalization can and cannot do (temporary, per-user, no data-model edits), and test Sort by Column for fixing month ordering.