Visualize and analyze the data

A company wants to create a Power BI report that shows sales performance by region. The data contains a table 'Sales' with columns: Date, Amount, RegionID, and ProductID. They also have a 'Regions' table with RegionID and RegionName. They want to display a matrix visual with RegionName on rows and Year on columns, with the sum of Amount as values. However, the report displays only 'RegionID' instead of 'RegionName'. What is the most likely cause?

A Power BI report includes a bar chart showing total sales by product category. The report designer wants to add a trend line to the chart to show the overall sales trend over time. Which type of visual should be used instead?

A Power BI report contains a table visual that displays employee names and their total sales. The data model includes an Employee table with columns: EmployeeID, Name, Department, and HireDate. The Sales table has columns: SaleID, EmployeeID, Amount, and SaleDate. The relationship between Employee and Sales is one-to-many. The user wants to see only employees who have made at least one sale. However, the table shows all employees, including those with no sales (blank Amount). What is the most likely reason?

A data analyst creates a Power BI report that uses a date table with a continuous date range. They want to calculate the running total of sales over the last 12 months, ending on the last date in the current filter context. Which DAX expression should they use?

You need to create a measure that calculates the year-over-year growth percentage for sales. Which DAX function should you use?

A company uses Row-Level Security (RLS) in Power BI. They want to ensure that when a manager views the report, they see data for their own region plus any region where a salesperson reports to them. Which RLS approach should you implement?

A Power BI report contains a page with many visuals that use a large DirectQuery dataset. The report is slow to load. Which design change would most improve the initial page load time?

Which are valid ways to create a calculated table in Power BI? (Select all that apply)

Which TWO are required components of a Power BI Paginated Report?

A Power BI report shows a bar chart with sales by region. When users click on a region, they expect a line chart on the same page to filter to that region's sales over time. However, the line chart does not respond to the click. What is the most likely cause?

A company has a dataset with a table 'Orders' containing columns: OrderDate, CustomerID, Amount. They want to create a visual that shows the total amount per month. Which of the following is the best approach?

Drag and drop the steps to configure a scheduled refresh for a dataset in the Power BI service into the correct order.

You have a Power BI report that shows sales by product category. The report is used by the sales team, who need to see the data at a regional level. You want to allow users to switch between viewing data for all regions and a specific region without creating multiple pages. Which feature should you use?

You have a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. You need to add a new measure to the report. What should you do?

You have a Power BI dataset that includes a 'Sales' table and a 'Calendar' table. You need to create a measure that calculates the running total of sales over the last 12 months, ending on the last date in the current filter context. Which DAX function should you use?

Which TWO actions can you perform using Power BI Desktop's Query Editor? (Choose two.)

Which THREE of the following are valid considerations when using Power BI's AI visuals? (Choose three.)

You receive the above JSON policy for a Power BI dataset. You need to add a relationship between the 'Sales' table and a 'Calendar' table in the same dataset. What must you modify in the JSON?

You are creating a Power BI report to visualize customer feedback scores. The data contains a column 'FeedbackDate' with dates and a column 'Score' with values from 1 to 10. You want to show a trend line of average score over time. Which visual type is most appropriate?

You have a Power BI dataset with a 'Sales' table that includes a 'ProductID' column. You also have a 'Products' table with 'ProductID' and 'Category' columns. You create a relationship between the tables. You want to create a measure that calculates the total sales for products in the 'Electronics' category. Which DAX expression should you use?

Which THREE of the following are valid methods to enhance the accessibility of a Power BI report? (Choose three.)

Refer to the exhibit. You have a DAX measure that calculates year-over-year sales growth. When you add this measure to a table visual with Year and Month, some rows show blank values. What is the most likely cause?

You have a Power BI report with a matrix visual showing sales by region and product category. You want to allow users to expand and collapse groups. Which feature should you enable?

You are designing a Power BI report page. Which two actions can you take to improve the accessibility of the report?

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. Which three steps should you take to troubleshoot?

You are creating a Power BI report that uses a composite model with DirectQuery and imported tables. Which two considerations should you keep in mind?

You have a Power BI report that includes a line chart showing monthly sales. You want to add a forecast for the next six months. Which feature should you use?

You are designing a Power BI report for a sales team. They need to see their individual performance compared to team averages. You have a table with columns: Salesperson, Region, SalesAmount. Which visual best allows each salesperson to see their own value alongside the average?

Refer to the exhibit. You have a DAX measure that calculates customer lifetime value (CLV) as total revenue divided by distinct customer count. When you use this measure in a visual with Product category, you notice that the CLV values are higher than expected. What is the most likely reason?

You are designing a Power BI report for a sales team. The team needs to see revenue by product category, but also want to view daily trends for a selected product. The data has over 10 million rows. What visual design approach minimizes report load time?

You want to create a measure that calculates the percentage of total sales for each product category. What DAX function should you use to get the grand total?

You have a Power BI semantic model with a date table that has a 1:* relationship to a Sales table. You need to create a measure that shows the number of sales transactions for the last 30 days. The date table is marked as a date table. Which DAX expression should you use?

Which THREE of the following are best practices when designing Power BI reports for mobile devices? (Select three.)

Which THREE of the following are valid considerations for choosing between Import and DirectQuery storage modes? (Select three.)

You have a Power BI report that shows sales by region. The map visual displays regions with incorrect boundaries. What is the most likely cause?

You need to create a measure that calculates the year-over-year growth of sales. Which DAX function should you use?

You are designing a report for executives. They need to see both high-level KPIs and the ability to drill down into details. Which approach should you recommend?

You need to ensure that a Power BI report is accessible to users with visual impairments. Which feature should you configure?

You have the DAX measure shown. The measure returns blank for some periods even though there are sales in the current period. What is the most likely cause?

You have a Power BI report that uses a measure with a filter context. You want to override the filter context for a specific calculation. Which function should you use?

Which TWO actions can improve the performance of a Power BI report that uses DirectQuery?

Which THREE features are available in Power BI to support natural language queries?

You are reviewing a Power BI dataset schema. The Date column is used in time intelligence measures. What is missing from this schema?

You are building a report to analyze sales performance by region. You need to allow users to dynamically switch between viewing data as a bar chart and a line chart without modifying the report page. Which feature should you use?

You have a Power BI report with the DAX measure shown in the exhibit. Users report that the measure returns blank for some months even though sales data exists for both current and previous years. What is the most likely cause?

You need to create a report that calculates running total of sales over time. Which Power BI feature should you use?

You need to design a report that allows users to see sales data at the year, quarter, and month levels, with the ability to expand and collapse hierarchies. Which visual type should you use?

Which THREE actions can help optimize a Power BI report's performance? (Select THREE.)

Which TWO chart types are appropriate for comparing proportions of a whole? (Select TWO.)

You have a measure as shown in the exhibit. The sales amount is not accumulating correctly; instead, it shows the total sales for all dates, regardless of the selected date filter. What is the problem?

You need to create a visual that displays the sales trend over the last 12 complete months. Which approach should you use?

You have a report that uses a live connection to a Power BI dataset. You want to add a table visual that shows sales by product, but you notice that you cannot add a calculated column. What is the reason?

You need to create a visual that shows the relationship between advertising spend and website traffic. Which type of visual is most appropriate?

You want to allow users to highlight different product categories in a line chart by selecting from a list. Which feature should you add?

Your Power BI report includes a map visual showing store locations. However, some locations are not appearing correctly because of ambiguous place names. What should you do to ensure accurate geocoding?

Which TWO actions are best practices for designing accessible Power BI reports? (Choose two.)

Which TWO visuals are most suitable for showing the distribution of a single numeric variable? (Choose two.)

You need to allow users to ask questions about their data using natural language. Which Power BI feature should you enable?

A Power BI report shows a line chart of monthly sales. The user wants to add a horizontal line representing the target sales of $100,000. Which approach should you recommend?

You are designing a Power BI report for executives. The dataset contains sales data with a many-to-many relationship between 'Sales' and 'Product' tables via a 'ProductSales' bridge table. Users complain that some measures return incorrect totals when using multiple related fields. What is the most likely cause?

You need to create a visual that shows the contribution of each product category to total sales over time. Which visual type is most appropriate?

Refer to the exhibit. The DAX measure is intended to return the previous purchase amount for the same customer. However, it returns the current row's amount for most rows. What is the most likely reason?

You have a Power BI report with a matrix visual showing sales by year and quarter. Users want to drill down from year to quarter and expand back up. Which feature should you enable?

You need to create a measure that calculates the year-over-year growth percentage for sales. Which DAX function combination is most appropriate?

You are troubleshooting a Power BI DirectQuery model that connects to a SQL Server database. A slicer on 'Region' is slow to respond. The region column has 50 distinct values. What is the best optimization?

Which TWO actions can improve the performance of a Power BI report that uses DirectQuery? (Select two.)

Which THREE factors should you consider when designing a Power BI data model for a star schema? (Select three.)

Which TWO Power BI visuals can be used to display hierarchical data? (Select two.)

You need to design a report that allows users to drill from a yearly sales summary to quarterly details, then to monthly details, while maintaining the ability to go back. Which visual interaction should you enable?

You have a report page that shows sales by region. You want users to be able to select a region and see the corresponding sales details on the same page without navigating away. Which feature should you use?

You need to create a visualization that shows the contribution of each product category to total sales over time. Which chart type is most appropriate?

You have a report that contains a map visual showing sales by city. Several cities are missing from the map because the location data is ambiguous. What should you do to resolve this?

You want to allow users to filter a report by a specific date range (e.g., last 30 days) without requiring manual selection. Which approach should you take?

You have a report that uses a custom visual from AppSource. The visual is not rendering correctly after a Power BI Desktop update. What is the best course of action?

Which TWO actions improve the accessibility of a Power BI report for users with visual impairments?

Which THREE considerations are important when designing a dashboard for executive stakeholders?

Which TWO actions can you take to improve the performance of a Power BI report that uses a large dataset?

You have a Power BI report that uses a measure to calculate year-over-year growth. Users report that the measure returns blank for certain months. The measure is: YoY Growth = DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))). What is the most likely cause of the blank values?

You need to create a Power BI report that allows users to select a single measure from a list to display on a card visual. Which feature should you use?

You are designing a Power BI report that will be viewed on mobile devices. The report contains a complex scatter plot with many data points. Users complain that the visual is hard to interact with on small screens. What is the best approach to improve the mobile experience?

You want to create a Power BI report that allows users to ask questions in natural language and get visual answers. Which feature should you enable?

Which TWO of the following are valid ways to create a calculated table in Power BI? (Select two.)

Which THREE of the following are best practices for designing Power BI reports for accessibility? (Select three.)

You have a Power BI report that uses a DirectQuery connection to a large SQL Server data warehouse. Users report that slicers and filters are slow to respond. What should you recommend to improve performance?

You are building a Power BI report that uses a composite model with a DirectQuery source and an imported local table. You want to create a measure that aggregates data from both sources. What must you ensure?

You have a Power BI report that uses a calculated column to categorize sales as 'High', 'Medium', or 'Low'. You notice the column is not being refreshed when the underlying data changes. What is the most likely reason?

You are designing a Power BI report that will be viewed on mobile devices. The report includes many visuals. What is the best practice for optimizing the report layout for mobile?

You have a Power BI dataset with a fact table and multiple dimension tables. You need to ensure that when a user filters by a dimension, the filter propagates correctly to the fact table. What type of relationship should you use?

You are creating a Power BI report and want to allow users to ask questions about the data using natural language. Which feature should you enable?

Which TWO of the following are best practices for designing Power BI reports for accessibility? (Select TWO.)

You have a Power BI report that includes a pie chart. Users complain that it is difficult to compare the sizes of slices. Which visual should you recommend instead to improve comparison?

You create a Power BI report that includes a page with a matrix visual showing sales by region and product category. You want users to be able to drill down from region to salesperson level. What is the best way to enable this?

You have a Power BI dataset with a fact table containing sales transactions and a dimension table for customers. The customer dimension includes a calculated column that uses the LOOKUPVALUE function to retrieve a customer's region from another table. The report performance is slow. What should you do to improve performance?

You are building a Power BI report to analyze customer churn. You want to add a visual that shows the trend of churn rate over time. Which visual type is most appropriate?

You have a Power BI report that includes a map visual showing store locations. You want to add a tooltip that displays the store name and total sales when users hover over a location. What do you need to do?

You are designing a Power BI dashboard for executive management. Which TWO practices should you follow to ensure the dashboard is effective?

You are building a Power BI report that uses a DirectQuery source. Which TWO of the following actions can improve report performance?

You need to create a Power BI report that allows users to analyze sales data by multiple dimensions including date, product, and region. Which THREE features should you use to provide a good user experience?

You have a Power BI dataset that uses row-level security (RLS) with roles defined in Power BI Desktop. You publish the dataset to the Power BI service. Which TWO statements are true about RLS behavior?

You have a Power BI report that shows sales by region. Users report that the map visual is not displaying data for some countries. What is the most likely cause?

You need to create a measure that calculates year-over-year growth percentage. Which DAX function should you use?

You have a report with a line chart showing monthly sales. Users need to see the exact sales value when they hover over a data point. What should you configure?

You are designing a report for executives. The report contains a matrix visual with many rows and columns. Users complain that the visual is slow to render. Which design change would most improve performance?

You need to create a KPI visual that shows whether current sales are above or below target. Which fields are required for a KPI visual?

You want to create a custom visual that is not available in the default Power BI visuals pane. What should you do?

Which THREE of the following are best practices for designing Power BI reports for mobile devices?

You have the above M query. You need to load only the top 10 customers by sales. What should you add to the query?

You need to design a Power BI report that displays sales trend over time. The data includes dates with missing values for weekends and holidays. Which visualization type and approach should you use to ensure accurate trend representation?

You have a Power BI report with a matrix that shows sales by region and product category. Users complain that the matrix is too cluttered and hard to read. Which best practice should you apply to improve readability?

You want to create a report that allows users to select a product category and see the top 5 products by sales within that category. Which approach should you use?

You have a report with a map visual showing store locations by city. However, some cities are not displaying on the map. You verified that the city names are correct. What should you check first?

Which THREE actions can you take to improve the performance of a slow Power BI report that uses multiple visuals on a single page?

Refer to the exhibit. You have a Power BI measure defined as shown. Users report that when they filter by region, the measure always shows sales for the North region regardless of the filter. What is the most likely cause?

You are creating a Power BI report and need to visualize the relationship between two numerical variables, such as sales amount and profit. Which visual type is most appropriate?

You have a Power BI dataset that contains a table with sales data and a separate date table. You need to create a measure that calculates the total sales for the previous month relative to the selected date. Which DAX function should you use?

You have a Power BI report that includes a slicer for product category. Users want to select multiple categories and see the combined data. The slicer currently allows only single selection. What should you change?

You have a Power BI report that includes a line chart showing monthly sales. You want to add a trend line to help users identify the overall direction of sales over time. Which feature should you use?

You are creating a Power BI report to analyze customer churn. You have a table with Customer ID, Churn Date, and other attributes. You want to create a measure that calculates the number of customers who churned in the last 30 days. Which THREE components do you need?

You have a Power BI report that displays sales data by region. The report includes a map visual showing sales amount by state. You notice that some states are not displayed on the map because the state names in the data do not match the standard names used by Power BI's map visualization. For example, 'California' is correct but 'CA' is not recognized. You need to ensure all states appear correctly. Which action should you take? A. Create a calculated column that maps state abbreviations to full names using a SWITCH statement. B. Change the map visual to a filled map. C. Use the 'Data category' property to set the field to 'State or Province'. D. Add a custom map image. Which option is the best?

You have a Power BI report with a page that contains a bar chart showing sales by product category. You want to allow users to click on a bar and navigate to a different report page that shows detailed sales for that category. Which feature should you use?

You are optimizing a DAX query that returns product-country combinations with total sales over 10,000. The query runs slowly. What is the primary performance issue with this query?

You are a Power BI developer for a retail company. You have a semantic model that includes a 'Sales' fact table with columns: 'Date', 'ProductID', 'StoreID', 'Quantity', 'UnitPrice'. The 'Product' dimension table includes 'ProductID', 'ProductName', 'Category', 'SubCategory'. The 'Store' dimension table includes 'StoreID', 'StoreName', 'Region', 'District'. You need to create a report page that allows users to analyze sales performance by product category and store region. The report must include a matrix visual with: - Rows: Product Category - Columns: Store Region - Values: Total Sales Amount (Quantity * UnitPrice) Additionally, users must be able to drill down from category to subcategory in the rows, and from region to district in the columns. You also need to ensure that when a user selects a specific store region, the matrix only shows data for that region and its districts. You have created the measures and the matrix visual. However, when you test the drill down, the hierarchy does not work as expected: clicking the expand icon on a category does not show subcategories. What is the most likely cause?

You are working on a Power BI report for a marketing team. The report includes a page with a line chart showing website visits over time, and a table showing the top 5 marketing campaigns by conversion rate. The marketing manager wants to be able to click on a point in the line chart (representing a specific date) and have the table update to show only campaigns that were active on that date. The campaigns data includes a 'StartDate' and 'EndDate'. You have implemented a measure to filter campaigns based on the selected date. However, when you click on a date point in the line chart, the table does not update. What should you do to enable this interaction?

You are a Power BI analyst for a financial services company. You have a semantic model that contains a 'Transactions' fact table with millions of rows, and a 'Calendar' date dimension table. You need to create a report page that shows the year-to-date (YTD) total transaction amount compared to the same period last year (SPLY). The report must allow users to select a year from a slicer, and the YTD calculation should always be based on the maximum date in the data for the selected year (i.e., show YTD as of the latest available date). You have created the following measures: - Total Amount = SUM(Transactions[Amount]) - YTD Amount = TOTALYTD([Total Amount], 'Calendar'[Date]) - SPLY YTD = CALCULATE([YTD Amount], SAMEPERIODLASTYEAR('Calendar'[Date])) When users select a year from the slicer, the YTD Amount does not correctly show the YTD as of the last date in the selected year; instead, it shows the YTD for each individual date in the context. What is the most likely issue?

You are a Power BI consultant for a logistics company. The company has a semantic model with a 'Shipments' fact table (containing 'ShipmentID', 'Date', 'OriginCity', 'DestinationCity', 'Weight', 'Cost') and 'City' dimension table (with 'City', 'Region', 'Country'). The company wants a report that displays a map visual with bubbles sized by total shipment weight, and a slicer to select a region. Additionally, they want to be able to click on a bubble (city) and see a table of shipments from that city. You have implemented a map visual using the 'City' field and a table visual. When you click on a bubble, the table does not filter to show only shipments from that city. You have confirmed that cross-filtering is enabled. What is the most likely cause?

You are a Power BI report creator for a non-profit organization. You have a semantic model with a 'Donations' fact table (columns: 'DonationID', 'DonorID', 'Date', 'Amount', 'CampaignID') and a 'Donors' dimension table (columns: 'DonorID', 'DonorName', 'City', 'DonorType' (Individual/Corporate)). You need to create a report page that shows a scatter chart with 'Total Donation Amount' on the X-axis and 'Number of Donations' on the Y-axis, with each point representing a donor type. You also want to add a trend line to show the correlation. When you create the scatter chart, only one point appears (for all donors combined), instead of separate points for Individual and Corporate. What is the most likely cause?

You have a Power BI report connected to a dataset containing a table named Sales with columns OrderDate (date), ProductCategory (text), and SalesAmount (decimal). You create a report page with a line chart showing SalesAmount over OrderDate. Users want to quickly change the date granularity from daily to monthly and also switch between ProductCategory values without editing the report. The page currently has no slicers or filters. You need to add interactive controls that allow users to change the date hierarchy level and filter by product category. What should you do?

You have a Power BI report with a card visual that displays total sales. Users report that when they apply a date filter using the slicer, the card visual does not update. You have verified that the slicer is properly configured to filter the date table. What is the most likely cause?

You are creating a Power BI report for a sales team. The report contains a clustered bar chart showing total sales by product category. The sales manager wants to see the exact sales amount for each category without hovering over the bars. You need to configure the visual to display the values directly on the chart. What should you do?

You are creating a Power BI report and need to add a visual that allows users to dynamically change the measure displayed in a chart. Which feature should you use?

You are a data analyst for a healthcare organization. You have a Power BI report with a clustered bar chart that displays patient counts by department. The report is used by hospital administrators who need to identify which department has the highest patient count. They also want to see the exact patient count for each department without hovering. Which feature should you enable on the visual to meet this requirement?

You are a Power BI data analyst for a healthcare organization. You build a report page containing a card visual that displays total patient admissions, a slicer for hospital department, and a table visual listing patient details. A physician selects the 'Cardiology' department in the slicer. She then notices that the card visual updates to show only Cardiology admissions, but the table visual still shows all patients from every department. She wants both visuals to respond to the slicer. What should you do?

You are a Power BI data analyst for a healthcare organization. You have a report page with a card visual that displays total patient count. The CEO wants to see the patient count broken down by age group (0-18, 19-35, 36-50, 51-65, 65+) and by gender, with the ability to expand or collapse each age group to see gender details. You need to add a visual that supports this hierarchical drill-down. Which visual should you use?

You are a Power BI data analyst for a manufacturing company. You have a report with a scatter chart that plots production cost (X-axis) versus defect rate (Y-axis) for various production lines. You want to enable users to quickly identify production lines that have both high cost and high defect rate. You decide to add a reference line that divides the chart into quadrants. What should you do?

You are a Power BI data analyst for a manufacturing company. You have a report with a line chart showing daily production output over the past year. Users report that the line chart is cluttered and difficult to read due to daily fluctuations. You need to add analytics features to the line chart to help users identify trends and outliers. Which two features should you add? (Choose two.)

You are a Power BI data analyst for a marketing agency. You create a report with a pie chart showing the percentage of total website traffic by device type (Desktop, Mobile, Tablet). A stakeholder asks you to change the chart so that it shows the actual number of sessions for each device type instead of percentages. What should you do?

You have a Power BI report with a map visual showing sales by city. You want to ensure that cities with higher sales are represented by larger bubbles. What should you do?

You are a Power BI data analyst for a marketing agency. You have a report page with several visuals that display campaign performance metrics. The page is getting crowded, and you need to provide users with a way to view different sets of visuals without creating multiple report pages. You decide to use bookmarks and a bookmark navigator. What should you do to ensure that users can switch between views seamlessly?

You are a Power BI author for a marketing agency. You have a report with a pie chart showing the percentage of total leads by source. The report is shared with clients who view it on mobile devices. The pie chart's legend is taking up too much space and making the chart small. What should you do to improve the mobile experience?

You are a Power BI data analyst for an e-commerce company. You have a report with a matrix visual that shows product categories as rows and years as columns, with total sales as values. You want to add a sparkline to each row that shows the trend of sales over the years. What should you do?

You are creating a Power BI report that includes a matrix visual showing sales by year and quarter. Users want to be able to expand and collapse the quarters within each year. What should you do?