PL-300

Practice PL-300 Exam

Is it difficult for you to decide to purchase Microsoft PL-300 exam dumps questions? CertQueen provides FREE online Microsoft Power BI Data Analyst PL-300 exam questions below, and you can test your PL-300 skills first, and then decide whether to buy the full version or not. We promise you get the following advantages after purchasing our PL-300 exam dumps questions.
1.Free update in ONE year from the date of your purchase.
2.Full payment fee refund if you fail PL-300 exam with the dumps

Full PL-300 Exam Dump Here

Latest PL-300 Exam Dumps Questions

The dumps for PL-300 exam was last updated on Oct 23,2025 .

Viewing page 1 out of 14 pages.

Viewing questions 1 out of 73 questions

Question#1

You have the CSV file shown in the following table.

You use Power Query Editor to preview the data in the file.
You need to transform the data to meet the following requirements:
• The first column must contain the month.
• The second column must contain the year.
• The third column must contain the order amount for the month and year.
Which transformation should you use first?

A. unpivot

B. pivot

C. transpose

D. remove

Question#2

DRAG DROP
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Explanation:
1- Convert list to table
2- Expand Column
3- Set Date type
Here is an example: https://youtu.be/B4kzyxnhQfI
The definition of the function which expand columns: https://docs.microsoft.com/en-us/powerquery-m/table-expandrecordcolumn

Question#3

DRAG DROP
You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.
The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.
You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.
How should you complete the calculation? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Explanation:
Divide, Calculate, AllSelected.
Reference: https://docs.microsoft.com/en-us/dax/allselected-function-dax

Question#4

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?

A. Enable personalization for each Visual.

B. Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart

C. Edit the interactions between the three visuals.

D. Enable personalization for the report