Question 1 of 30
A financial analyst is using Power BI to visualize sales data from multiple regions. During the data import process, the analyst encounters an issue where some of the sales figures appear as null values. After investigating, the analyst discovers that the data source has inconsistent formatting for the sales figures, with some entries recorded as text instead of numbers. What is the most effective approach to resolve this issue and ensure that all sales figures are accurately represented in Power BI?
Transform the data in Power Query to convert text entries to numbers and replace null values with zero.
Manually edit the data source to ensure all entries are in numeric format before importing into Power BI.
Use DAX functions to handle null values after the data has been imported into Power BI.
Create a new report in Power BI that excludes any entries with null values.

Preparing for Microsoft DP-500 Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI? 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