Question 1 of 30
A company is analyzing its sales data using Power BI to identify trends over the last fiscal year. They have a dataset that includes sales figures, product categories, and regions. The management wants to create a report that visualizes the total sales per product category for each region, and they also want to include a slicer to filter the data by month. Which of the following steps should be taken first to ensure that the report is set up correctly for this analysis?
Create a relationship between the sales data and the date table to enable time-based filtering.
Import the sales data into Power BI without any modifications.
Create a bar chart visual to display total sales by product category.
Add a slicer for product categories to the report.

Preparing for Microsoft MB-800 Microsoft Dynamics 365 Business Central Functional Consultant? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free