Visualize and analyze the data

A Power BI report uses a measure that calculates Year-over-Year sales growth. Users report that the measure shows incorrect values for January 2024 when compared to January 2023. The data model contains a Date table with a continuous date range from January 1, 2020 to December 31, 2024. Which DAX function is most likely causing the issue?

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?

A Power BI report includes a slicer for 'Year' and a line chart showing monthly sales. The report designer wants to ensure that when a user selects a year in the slicer, the line chart shows only the months of that year, with month names on the x-axis sorted chronologically. Which TWO actions must be taken?

A company has a Power BI dataset that includes a table 'Orders' with columns: OrderID, CustomerID, OrderDate, ShipDate, and Amount. They want to create a measure that calculates the number of orders shipped within 3 days of the order date. Which THREE of the following steps are necessary to create this measure?

A company has a Power BI report that uses a DirectQuery dataset from an Azure SQL Database. Users report that the report is slow when filtering by date. Which action should you take to improve performance?

A Power BI report uses a composite model with a DirectQuery source and an imported table. The imported table has many rows, and the report is taking a long time to refresh. What is the most likely cause?

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 TWO are valid ways to create a calculated table in Power BI?

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

A Power BI developer writes the Power Query M code shown in the exhibit. The code runs successfully but returns an error when the user selects a year from a slicer in the report. The error states: 'Expression.Error: The key did not match any rows in the table.' Which is the most likely cause?

A Power BI admin applies the Azure Policy shown in the exhibit. What is the effect of this policy?

A sales manager wants to create a report that shows year-over-year growth for each product category. They have a date table and a sales table with daily sales. Which DAX measure should they use to calculate the previous year's sales?

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?

Which TWO of the following are valid ways to create a measure in Power BI?

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

You are a Power BI analyst for a retail company. You have a dataset containing a 'Sales' table with columns: SalesDate, StoreID, ProductID, Quantity, UnitPrice, and Discount. You also have a 'Calendar' table marked as a date table with a continuous date range from 2018 to 2023. You need to create a measure that calculates the running total of sales amount (Quantity * (UnitPrice - Discount)) over the last 12 months, but only for products that have been sold in at least 10 different stores in the current month. The measure should be dynamic based on the current filter context (e.g., month, year). The report will be used by regional managers to monitor product performance. You have already created a base measure: TotalSales = SUMX(Sales, Sales[Quantity] * (Sales[UnitPrice] - Sales[Discount])). Which DAX measure should you create?

You are building a report for a logistics company. The dataset includes a 'Shipments' table with columns: ShipmentID, ShipDate, OriginCity, DestinationCity, Weight, Revenue, and Carrier. The company wants to analyze revenue trends by carrier over time. They have a date table marked as a date table. You create a line chart with ShipDate on the axis and Revenue as the value, with Carrier as the legend. However, the line chart shows a single line for each carrier, but the revenue values are aggregated across all dates, showing a constant line. What is the most likely cause?

You are developing a Power BI report to analyze sales performance. The data model includes a 'Sales' fact table with a 'Date' column and a 'Region' dimension table. You need to create a measure that calculates the total sales amount for the current year compared to the previous year. Which TWO of the following steps are required to implement this calculation correctly?

You are reviewing a Power Query M script that imports sales data. The script filters orders from 2023, groups by CustomerID to sum SubTotal, sorts descending, and takes the top 10 customers. However, the query fails with an error. What is the most likely cause?

You are a Power BI analyst at a retail company. The company has a Power BI dataset that imports daily sales data from an on-premises SQL Server database. The dataset includes tables: 'Sales' (columns: SaleID, ProductID, SaleDate, Quantity, UnitPrice, CustomerID), 'Products' (ProductID, ProductName, Category), and 'Customers' (CustomerID, CustomerName, Region). The report needs to display a matrix visual showing total sales amount (Quantity * UnitPrice) by Category (rows) and Year (columns). The report currently shows blank values for the matrix. You have verified that relationships exist between the tables and that there is a date table marked as a date table. The measure used is: Total Sales = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]). When you test the measure in a card visual, it returns a value. However, the matrix shows blanks. What is the most likely cause and solution?

Drag and drop the steps to import data from a SQL Server database into Power BI Desktop into the correct order.

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

Match each data connectivity mode to its description.

Match each DAX function category to an example function.

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 are designing a Power BI report to analyze customer churn. The data model includes a 'Customers' table and a 'Churn' table. You need to create a measure that calculates the churn rate for each month, defined as the number of customers who churned that month divided by the total number of active customers at the beginning of the month. What is the best approach?

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 report with a date table and a sales table. The above DAX measure is used in a visual that also shows 'Date[Year]' on the axis. What does this measure return?

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?

You are building a Power BI report to display sales data. You want to ensure that when users export the report data to Excel, the exported data respects the current filters and slicers applied in the report. What should you do?

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.)

Which TWO of the following are valid ways to share a Power BI report with external users who do not have a Power BI license? (Choose two.)

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 have a Power BI report that uses a DirectQuery connection to a SQL Server database. You need to improve the performance of a visual that shows a large number of data points. What is the best action to take?

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.)

You need to create a Power BI report that uses data from Microsoft Excel files stored in SharePoint Online. The data should refresh automatically every hour. What is the recommended approach?

You have a Power BI report that uses a bar chart to show sales by region. Users report that the chart is difficult to read because many regions have similar sales values. You need to improve the readability without changing the data. Which visual should you use?

You are designing a Power BI report for executives. They need to quickly see the top 10 products by revenue and the trend of revenue over the last 12 months. Which combination of visuals should you include on a single page?

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 building a Power BI report that uses a live connection to an Azure Analysis Services (AAS) tabular model. Users need to be able to filter data using a slicer that shows only products that have been sold in the current year. What should you do?

Refer to the exhibit. You have a JSON definition of a Power BI dataset. You need to ensure that when a user filters by Product[Category], the filters propagate to Sales table. What is the current cross-filtering behavior?

You have a Power BI report that uses a map visual to show store locations. Some stores have the same latitude and longitude. You want to distinguish overlapping points. Which visual feature should you use?

You are creating a Power BI report that includes a scatter chart with many data points. Users want to identify outliers quickly. Which approach should you recommend?

Refer to the exhibit. You have a DAX measure that ranks products by sales amount. When you add this measure to a table visual with ProductID and Sales Amount, you notice that the rank resets for each year when you add a Year slicer. What should you modify to ensure ranking is always across all products regardless of slicer?

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 have a Power BI report that uses a live connection to an Azure Analysis Services (AAS) model. Users report that the report takes a long time to load when they apply a slicer on a calculated column. What should you recommend?

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 report that uses Import mode. The dataset is refreshed daily. Users are complaining that the report shows data from yesterday morning even though the refresh completed successfully at 2:00 AM today. What should you check first?

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?

You need to create a Power BI report that shows sales by region and by product category. Users should be able to click on a region and see the sales for that region across all product categories. What is the best way to enable this?

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

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

Which TWO of the following are true about using AI visuals in Power BI? (Select two.)

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

Which TWO of the following are valid methods to share a Power BI report with external users who do not have an internal Microsoft Entra ID account? (Select two.)

You have a Power BI report that uses a composite model with both Import and DirectQuery sources. You need to ensure that a measure using SUMX performs well. What should you do?

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 have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. What should you check first?

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 dataset with a large fact table. You need to optimize report performance when users filter by date. What should you do?

You are building a report that uses AI visuals from Power BI. You want to automatically detect outliers in sales data. Which visual should you use?

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?

Which TWO are valid ways to distribute a Power BI report to users who do not have Power BI Pro licenses?

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

You have the DAX expression shown. It is intended to sum sales for the West region using an inactive relationship. However, the result is incorrect. What is the issue?

You have the measure shown. You add it to a table visual alongside columns from a related table. The total is higher than expected. What is the most likely cause?

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?

Your report contains a measure that calculates year-over-year growth. Users report that the measure returns blank for months where sales data exists in the current year but not in the previous year. How should you modify the measure to return 100% growth in such cases?

You want to create a visual that shows the top 5 products by sales amount, but also want to include an 'Other' category that aggregates all remaining products. Which approach 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 have a report page that shows sales by product category. You want to allow users to click on a category and see a detailed breakdown of products within that category on a separate page. Which Power BI feature should you implement?

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

You are reviewing a Power BI report with the JSON configuration shown in the exhibit. The visual is supposed to display the top 5 product categories by total sales, with all remaining categories grouped into 'Other'. However, the visual shows only the top 5 categories and no 'Other' bar. What is the most likely reason?

You have a report with a map visual showing store locations. You want to display a tooltip with additional store information (e.g., manager name, phone number) when a user hovers over a point. How should you achieve this?

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 TWO features can be used to implement row-level security (RLS) in Power BI? (Select TWO.)

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 the selected date only. 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 are creating a report in Power BI Desktop. You need to design a visual that shows sales trends over time and allows users to drill down from year to quarter to month. Which visual should you use?

Your Power BI report includes a bar chart showing monthly sales. Users complain that the bars are too crowded when viewing a full year. What is the best design change to improve readability?

Refer to the exhibit. A user created this measure to calculate sales for the same period last year. However, the measure returns incorrect values when used in a matrix with month granularity. What is the most likely cause?

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

Your Power BI report uses a custom visual that is not rendering in the Power BI service. The visual works correctly in Power BI Desktop. What is the most likely cause?

Refer to the exhibit. You are configuring a Power BI dataset for a real-time dashboard that must show data with no more than 5 minutes of latency. What is the impact of the current query caching setting?

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?

Refer to the exhibit. You run this DAX query and receive an error. What is the most likely reason?

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

Which THREE features can be used to create custom narratives in Power BI? (Choose three.)

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

Refer to the exhibit. You configure incremental refresh for a Power BI dataset with the above policy. The dataset contains 3 years of historical data. How will the rolling window affect the data?

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

Refer to the exhibit. You run this DAX query but the YoY Growth column returns blank for all rows. What is the most likely cause?

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?

A user wants to see the top 10 products by sales but also include a total row at the bottom of the table. How can you achieve this?

You create a bar chart showing sales by product category. You want to sort the categories by total sales descending. What should you do?

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.)

Refer to the exhibit. The DAX query is executed in DAX Studio. It returns a table with Category and Total Sales. However, the total sales values are incorrect because they include all categories regardless of context. What is the most likely issue?

Refer to the exhibit. This JSON defines a row-level security (RLS) role in Power BI. A user assigned to the 'Sales Manager' role runs a report that shows total sales across all regions. The sum displayed is lower than expected. What is the most likely reason?

You are a Power BI analyst at a retail company. The company has a SQL Server data warehouse with tables: 'Sales' (SalesID, ProductID, CustomerID, SalesDate, Amount, Quantity), 'Products' (ProductID, ProductName, Category, UnitPrice), 'Customers' (CustomerID, CustomerName, Region, Segment). The data warehouse is refreshed nightly. You need to build a Power BI solution that meets the following requirements: - The report must be published to the Power BI service and support scheduled refresh. - Users must be able to analyze sales by product category and customer region. - The data model should follow a star schema design. - A measure must calculate the running total of sales by date. - The report must include a visual that shows the top 5 products by sales amount for the current year. - Performance is critical; the report should load quickly. You have imported the data into Power BI Desktop. Which of the following actions should you take to meet the requirements?

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 are building a report that uses a calculated column with the formula: 'Profit = Sales[Revenue] - Sales[Cost]'. Users report that the Profit column shows negative values for some rows when it should be positive due to a known data issue in the Cost column. What is the best approach to handle this without modifying the source data?

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 are designing a report for mobile users. Which layout consideration is most important to ensure usability on small screens?

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 are building a Power BI report that shows sales by region. You want to use a visual that displays hierarchical data, such as region -> country -> city, and allows drilling up and down. Which visual should you use?

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?

You have a Power BI dataset that contains a table with sales data and a separate date table. You create a measure that uses CALCULATE and DATESYTD to show year-to-date sales. The measure returns incorrect values for the first month of the year. What is the most likely cause?

You are troubleshooting a Power BI report that uses a measure with the following formula: Profit Margin = DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue])). The measure returns blank for rows where revenue is zero. You want to display 0% instead of blank. What should you do?

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.)

Which TWO of the following are required to use Copilot in Power BI? (Select two.)

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 designing a Power BI report for executives. The report must show sales performance across regions, with the ability to drill down from region to country to city. The data model includes a Sales table and a Geography table. Which type of hierarchy should you create in the Geography table to enable drill-down?

You are creating a Power BI report that includes a matrix visual showing sales by product category and year. You want to highlight the highest sales value in each category. Which conditional formatting option should you use?

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.)

Which THREE of the following are valid ways to share a Power BI report with users who do not have a Power BI Pro license? (Select THREE.)

Which TWO of the following are valid ways to create a calculated table in Power BI? (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 have a Power BI report that uses a live connection to an Azure Analysis Services tabular model. Users report that the report loads slowly when filtering by a specific date range. You need to improve performance without changing the data source. What should you do?

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?

Your Power BI report uses a calculated table to create a date dimension. You need to add a column that shows the fiscal quarter based on a fiscal year starting in July. What DAX expression should you use?

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 uses a composite model with a DirectQuery source (SQL Server) and a local imported table. The report includes a measure that calculates sales growth by comparing current year to previous year. Users report that the measure returns blank for months with no data in the current year. How should you modify the measure to show 0% growth instead of blank?

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 have a Power BI dataset that includes a Sales table with a column 'TransactionDate'. You need to create a date dimension table using DAX. Which THREE of the following are recommended practices?

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 are a Power BI data analyst at a global retail company. Your organization uses a SQL Server data warehouse to store sales transactions, product inventory, and customer demographics. The data warehouse is updated nightly. You have been tasked with building a Power BI report to analyze sales performance across different regions and product categories. The report must meet the following requirements: - Allow users to filter data by date, region, and product category. - Provide drill-down from region to store level. - Display key metrics such as total sales, sales growth compared to the previous year, and profit margin. - Ensure that the report loads quickly even when users apply multiple filters. - Users must be able to export the underlying data to Excel for further analysis. - The report should be accessible on mobile devices with a responsive layout. - You need to implement row-level security so that regional managers can only see data for their own region. - The dataset must support scheduled refresh. You have imported the necessary tables from the data warehouse using Import mode. You created a date dimension table using DAX and marked it as a date table. You also created a separate table for regions with a column 'RegionManagerEmail' that maps each region to the manager's email address. You plan to use RLS by creating a role that filters the region table based on the user's email address. After publishing the report to the Power BI service, you notice that the report takes a long time to load when users select a large date range. Additionally, the profit margin measure, which is calculated as DIVIDE(SUM(Sales[Profit]), SUM(Sales[Revenue])), returns blank for some rows even though both Profit and Revenue have values. You also receive feedback that the mobile layout is not optimized; the visuals are too small and the slicers are not accessible. You need to address these issues. What should you do?

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 have a Power BI report that uses a slicer to filter data by year. You want the slicer to show only years that have data, but currently it shows all years from 2000 to 2030. What is the most likely cause?

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 create a report that uses an AI visual to find key influencers. Which type of field can the AI visual analyze as the 'analyze' field?

You have a Power BI dataset with a many-to-many relationship between Sales and Product. You need to create a measure that sums sales amount by product category, but the relationship is causing incorrect totals. What is the best solution?

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

Which TWO of the following are valid ways to share a Power BI report with external users who do not have a Power BI license?

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

Which TWO of the following are valid ways to create a calculated table in Power BI?

You have the above DAX measure. When you add it to a table visual with Year and Month, the values are correct for each month. However, when you add a slicer for Year and select 2023, the measure shows blank for all months. What is the most likely cause?

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 see the above XMLA response when querying a Power BI dataset. You want to create a measure that calculates the difference between current sales and previous year sales, but you want to use the calculation group to avoid writing multiple measures. Which measure expression should you use?

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 are building a report for executives to monitor key performance indicators (KPIs) against targets. You have a KPI visual for revenue. The target is stored in a separate table. Which approach should you use to configure the KPI visual correctly?

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 Power BI report that uses a date hierarchy (Year, Quarter, Month) on the axis of a line chart. Users want to drill down from year to quarter to month. However, the drill-down feature is not working. What is the most likely cause?

You need to create a measure that calculates the total sales for the previous month, regardless of any filters on the date slicer. The data model includes a separate date table with a relationship to the sales table. Which DAX expression 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 TWO measures will correctly calculate the total sales for the current year, ignoring any filters on the date column? (Assume a proper date table with relationship.)

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

Which TWO DAX functions can be used to create a dynamic title that shows the currently selected year in a report, assuming a date table with a Year column?

Which THREE steps are required to set up row-level security (RLS) in Power BI Desktop?

You are a Power BI analyst for a multinational retail company. The company's sales data is stored in an Azure SQL Database with tables: Sales (SalesID, Date, ProductID, Quantity, Amount), Products (ProductID, ProductName, Category), and Calendar (Date, Year, Month, Day). The Sales table contains 500 million rows. You are creating a Power BI report to analyze daily sales trends over the past 5 years. The report must allow users to drill from year to month to day using a hierarchy. The performance of the report is critical; users expect visuals to load within 5 seconds. The current model imports all tables without any optimization, and the date hierarchy visual takes over 30 seconds to render. You need to redesign the data model to meet the performance requirement. What should you do?

You are building a Power BI report for the HR department to analyze employee turnover. You have an Employee table with columns: EmployeeID, Name, Department, HireDate, TerminationDate (nullable). The report must include a measure that calculates the number of active employees as of the last day of each month. The data model also includes a Calendar table with a continuous date range. The measure must be accurate regardless of any slicer selections on the Calendar table. You need to write the DAX measure. Which measure should you use?

You have a Power BI report that uses a live connection to an Azure Analysis Services tabular model. Users report that the report is slow to load. You need to improve performance without changing the data model. What should you do?

You are designing a Power BI report for executive leadership. The report must display key performance indicators (KPIs) with current values and trend arrows. Which visual type should you use?

You have a Power BI report that uses a DirectQuery dataset from Azure Synapse Analytics. Users complain that applying a filter on a date slicer takes over 30 seconds. The underlying table contains 500 million rows. You need to improve slicer responsiveness. What should you do?

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 report with a page that contains a matrix visual showing sales by year and quarter. Users want to be able to drill down from year to quarter and then drill up again. The matrix currently shows only year. What should you configure?

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 uses a composite model with a DirectQuery source from Azure SQL Database and an imported table from Excel. You need to ensure that when a user filters the imported table, the DirectQuery table is also filtered accordingly. What should you configure?

You are designing a Power BI report to analyze sales performance across multiple regions. The data includes a Date table with a Many-to-One relationship to Sales. You need to ensure that users can drill down from Year to Quarter to Month in a matrix visual. What must you configure on the Date table?

You have a Power BI report that uses DirectQuery to a SQL Server database. Users report that the report is slow when filtering by a slicer on a large dimension table. You need to improve performance without changing the data source. Which approach should you take?

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 building a Power BI report from a large dataset (10 GB) stored in Azure Synapse Analytics. The dataset includes a fact table with 500 million rows. You need to minimize the amount of data imported into Power BI while still allowing users to filter by year and product category. Which approach should you use?

You are designing a Power BI dashboard for executive review. The dashboard must include a card visual showing the total sales for the current year. You need to ensure that the card visual updates automatically when data refreshes. Which TWO actions should you take?

You have a Power BI report that uses a composite model with a DirectQuery source and an imported table. Users report that some visuals show incorrect totals when using measures that reference both sources. Which THREE conditions must be met to ensure correct results?

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 are reviewing a DAX query that returns total sales by year and quarter. However, the result includes rows for quarters with no sales. Which modification should you make to exclude empty rows?

You are a data analyst for a retail company with stores across 50 states. You have a Power BI dataset that imports sales data from a SQL Server database daily. The fact table contains 200 million rows and includes columns: StoreID, ProductID, DateKey, SalesAmount, Quantity, and Discount. You also have dimension tables for Store, Product, and Date. Users report that a report page with a matrix visual showing SalesAmount by Store and ProductCategory takes over 30 seconds to render. You need to improve the performance of this visual without changing the data source or reducing the data granularity. You have the following options: A. Change the matrix visual to a table visual. B. Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount. C. Enable 'Show items with no data' on the matrix. D. Use a measure that sums SalesAmount and use the 'Filter' pane to restrict to top 100 rows. Which option should you choose?

You are building a Power BI report for the HR department. You have a table 'Employees' with columns: EmployeeID, Name, Department, HireDate, Salary, and ManagerID. You need to create a hierarchy for organizational chart that allows users to drill from CEO down to individual employees. The hierarchy should be dynamic based on the ManagerID. Which approach should you use? A. Create a parent-child hierarchy using DAX PATH and PATHITEM functions. B. Create a calculated column that concatenates all manager levels. C. Use the built-in drill-down feature with a matrix visual. D. Create separate tables for each level and merge them. Which option is the best?

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 dataset that includes a table 'Orders' with columns: OrderDate, CustomerID, ProductID, Quantity, and Revenue. You need to create a measure that calculates the running total of Revenue over the last 12 months, but only for products that have been sold in the current month. The measure should be used in a line chart showing monthly revenue. You have the following options: A. Use the TOTALQTD function with a filter for last 12 months. B. Use CALCULATE with DATESINPERIOD and a filter on products with sales in the current month. C. Create a calculated column for running total and then sum it. D. Use the WINDOW function (Preview). Which option should you choose?

You are a Power BI administrator for a large enterprise. You have a shared dataset that is used by multiple reports. The dataset contains sensitive financial data. You need to implement row-level security (RLS) so that managers can only see data for their own region. The dataset has a table 'Sales' with RegionID, and a table 'Managers' with ManagerID, ManagerName, and RegionID. You need to create an RLS role that filters the Sales table based on the logged-in user's region. You have the following options: A. Create a role with a DAX filter: 'Sales[RegionID] = USERPRINCIPALNAME()'. B. Create a role with a DAX filter: 'Sales[RegionID] = LOOKUPVALUE(Managers[RegionID], Managers[ManagerName], USERPRINCIPALNAME())'. C. Create a role with a DAX filter: 'Sales[RegionID] = USERNAME()'. D. Create a role with a static filter for each region. Which option should you choose?

You have a Power BI report that uses a date table with a continuous date range. You want to add a slicer that allows users to select a single month and then display data for that month only. You add a slicer visual with the Date field. However, the slicer shows individual dates instead of months. How should you configure the slicer to show months? A. Change the slicer type to 'Between' and then select a month range. B. Create a calculated column for Month and use that in the slicer. C. Use the 'Hierarchy' slicer with Date hierarchy. D. Set the slicer to 'List' and enable 'Show select all'. Which option is best?

You have a Power BI report that displays key performance indicators (KPIs) using a KPI visual. The visual shows a measure 'Current Sales' with a goal of 'Target Sales'. You want to show the status (on track, behind, etc.) based on the difference. You configure the KPI visual with the measure, goal, and trend axis. However, the status indicator does not appear. What should you do? A. Ensure the measure and goal are both numeric and have the same unit. B. Add a trend line to the visual. C. Set the 'Direction' property to 'High is good' or 'Low is good'. D. Use a different visual like a gauge. Which option is the best?

You are building a Power BI report to analyze sales performance. You need to allow users to dynamically switch between different measures (e.g., Sales Amount, Sales Quantity, Profit Margin) using a single slicer. Which two features should you implement?

You are designing a Power BI report for the executive team. The report must meet the following requirements: - The report must be accessible to users with visual impairments. - Visuals must automatically adjust to display the most important data when viewed on mobile devices. - Users must be able to drill through from a summary page to a detail page by clicking on a data point. Which three features should you implement?

You are creating a Power BI report to analyze customer feedback. You need to display the distribution of feedback ratings (1-5 stars) and also show the trend of average rating over time. Which two visual types should you use?

You run the above DAX query in DAX Studio. The result shows profit margin values for each year, but all values are the same for every year despite sales amounts varying. What is the most likely cause?

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 designing a Power BI report for a sales team. The team needs to see the top 10 products by sales amount, but also want to see the sales amount for all other products aggregated as 'Others'. What is the best approach to create this visual?

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 developer for a healthcare organization. You have a semantic model with a 'PatientVisits' fact table (columns: 'VisitID', 'PatientID', 'Date', 'Department', 'DurationMinutes', 'Cost') and a 'Patients' dimension table (columns: 'PatientID', 'Age', 'Gender', 'City'). You need to create a report page that shows the average cost per visit by department and age group. The age groups are: 0-18, 19-35, 36-50, 51-65, 65+. You want to use a custom visual that displays a matrix with departments as rows and age groups as columns, and the value as average cost. You have created a calculated column for age groups in the Patients table. However, when you place the age group column in the matrix columns, the values are not aggregated correctly; instead, each age group shows the same average cost as the overall average. 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?