You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette. You are creating a Power Bl dashboard that will include two visuals from each report You need to use a consistent dark theme…

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as…

You are building a Power Bl report that uses data from an Azure SQL database named erp1. You Import the following tables. You need to perform the following analyses: • Orders sold over time that include a measure of the…

From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR. You need to ensure that the HR team members have RLS applied when they…

You have a dataset that has the permissions shown in the following exhibit. A. Explanation

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following…

You are creating a Power BI model that contains a table named Store. Store contains the following fields. You plan to create a map visual that will show store locations and provide the ability to drill down from Country to…

You have a Power Bl query named Sates that imports the columns shown in the following table. Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis. You need…

You have a Power Bl report that contains a measure named Total Sales. You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete…

DRAG DROP You have a Power Bl table named Customer that contains a field named Email Address. You discover that multiple records contain the same email address. You need to create a calculated column to identify which records have duplicate…