Visualize and analyze the data

You are finalizing a Power BI report that will be consumed by users who rely on keyboard navigation and screen readers. On the main page, several decorative shapes and a company logo image are being read aloud by the screen reader, and users must tab through them before reaching the key visuals. You need to ensure that keyboard users can move directly to the meaningful visuals in a logical sequence without the decorative elements interrupting them. What should you do?

You have a clustered column chart showing monthly Total Revenue by Product Category. The regional director notices that revenue dropped sharply from Q2 to Q3 and asks which factors contributed most to the decline across all your dimensions (Region, Channel, and Salesperson). You want Power BI to automatically rank and visualize the segments that drove the decrease without manually building additional visuals. Which built-in capability should you use?

A sales manager is reviewing a clustered column chart that shows total revenue by month. Revenue jumped sharply from April to May, and the manager wants Power BI to automatically break down which categories and regions contributed most to that specific month-over-month increase, without manually building additional visuals. Which built-in feature should you use?

A retail analyst has a line chart showing daily online sales over the past two years. Management wants Power BI to automatically highlight unexpected spikes and dips in the daily sales trend, along with possible explanations for each unusual value. Which built-in analytics feature should the analyst enable to meet this requirement with the least manual effort?

You are building a sales report page that must show either a clustered column chart or a matrix in the same screen area, letting users switch between them with a button. Both visuals already exist and are stacked in the same location. You want the button to hide one visual and show the other without navigating to a different page. What is the most reliable way to configure this toggle?

A sales report page contains several slicers (Region, Product Category, and Fiscal Year) plus multiple visuals. Business users complain that after exploring the data they cannot quickly return the page to its default, unfiltered state. You want to add a single button that instantly clears all slicer selections and resets the page to its original view, without navigating away or reloading the report. What should you do?

You are analyzing a scatter chart in Power BI Desktop that plots each customer's total spend on the X axis against order frequency on the Y axis. Management wants Power BI to automatically identify natural groupings of customers with similar spending and frequency behavior so the marketing team can target distinct segments. You want to do this directly on the existing scatter chart without writing DAX or manually defining ranges. What should you do?

You have a matrix visual showing monthly revenue by product category. Management wants each revenue cell shaded green when the value is at or above the category's target of 50,000, yellow between 30,000 and 49,999, and red below 30,000. The targets are fixed thresholds, not values stored in the model. You want the coloring to apply automatically as data refreshes. What is the most appropriate way to configure this?

You have a matrix visual showing monthly revenue by product category. Management wants each revenue cell to display a horizontal bar whose length is proportional to the value, while still showing the numeric revenue text inside the same cell so users can read exact figures. What is the most efficient way to achieve this?

A financial report includes a matrix showing monthly profit values by region. Management wants any negative profit value to appear in red text and positive values in green, based directly on each cell's own value. You want the color to update automatically as data refreshes without creating extra measures if avoidable. Which conditional formatting approach in the Format pane should you use for the profit field?

You build a matrix that shows each store's monthly revenue. Management wants a visual status indicator next to each revenue value: a green up-arrow when revenue meets or exceeds a target measure [Target], a yellow dash when it is within 10% below target, and a red down-arrow when it is more than 10% below target. You must implement this without adding extra columns to the table and without a separate visual. What should you do?

A report contains a table listing support tickets. One text column, TicketLink, stores full URLs pointing to each ticket in an external system. Currently the cells display the raw URL text, but stakeholders want each row to show a clickable hyperlink labeled with the ticket subject instead of the long URL. What should you configure?

You are designing an executive report page that contains a large sales matrix and four small KPI cards. Executives have asked that, when they click a 'Focus Sales' button, the entire page should dim except for the sales matrix, which should remain fully visible and prominent. Clicking a 'Reset View' button should return the page to normal. You want to implement this with the least effort and without hiding any visuals. Which approach should you use?

You publish a sales report to a Power BI workspace in a Premium capacity. The regional managers who consume the report have asked for a plain-language paragraph at the top of the overview page that automatically describes total sales, top-performing region, and month-over-month change, and that updates as they apply their own slicer selections. You want to add this with minimal manual authoring effort. Which report element should you add?

You are building a Power BI report in Power BI Desktop connected to a well-structured sales semantic model. Your manager asks you to quickly generate a first-draft report page that summarizes revenue by region and product category so the team can start reviewing layout ideas. You want to use Copilot to accelerate this initial page build. Before Copilot can create a report page from your natural-language prompt, which prerequisite must be satisfied?

You are building an executive sales report in Power BI Desktop with Copilot enabled in your Fabric workspace. Leadership wants a text block on the summary page that automatically writes a short paragraph describing the key totals and trends shown by the visuals on that page, and that updates its wording as users apply slicers. Which approach should you use?

A sales manager reviews a bar chart showing total revenue by product category. She wants that when users hover over any bar, a rich pop-up appears showing a mini trend line of monthly revenue plus the top customer for that category, instead of the default single-value tooltip. What is the correct way to implement this in Power BI Desktop?

You built a dedicated report page containing a card and a small line chart, then set its page type to 'Tooltip' in the Page Information settings. When you hover over data points on a bar chart on your main page, the default tooltip still appears instead of your custom tooltip page. What must you do so the custom tooltip page displays for the bar chart?

A sales manager wants an interactive visual where they can start from total revenue and progressively break it down by dimensions of their choosing (such as Region, then Product Category, then Salesperson). They also want Power BI to automatically suggest which dimension explains the highest or lowest values at each level. Which visual should you add to the report?

You build a drillthrough page named 'Product Details' that opens when users right-click a product in a summary page. During testing, you notice that after users navigate to the drillthrough page, they have no obvious way to return to the summary page from which they came. What is the recommended way to provide this return navigation with minimal effort?