You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.
You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?

You have a Power BI report that contains one page. The page contains two line charts and one bar chart.
You need to ensure that users can perform the following tasks for all three visuals:
Switch the measures used in the visuals.
Change the visualization type.
Add a legend.
The solution must minimize development effort.
What should you do?

You have a BI dataset and a connected report.
You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.
You grant the users the Build permission for dataset
What Should do next?

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 total order value
* Orders by attributes of products sold
The solution must minimize update times when interacting with visuals in the report. What should you do first?