PL-300 Exam QuestionsBrowse all questions from this exam

PL-300 Exam - Question 19


DRAG DROP

-

You receive annual sales data that must be included in Power BI reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

You need to create a report that meets the following requirements:

• Visualizes the Sales value over a period of years and months

• Adds a slicer for the month

• Adds a slicer for the year

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.

Show Answer
Correct Answer:

Discussion

17 comments
Sign in to comment
GuerreiroJunior
Jan 10, 2023

Correct Answer!

Igetmyrole
Sep 4, 2023

Here are the correct three actions should be performed in sequence: Action 1: Select the Month and MonthNumber Columns. These columns will be used for the slicers to filter the data by month. Action 2: Select unpivot other columns. This action will transform the 2019, 2020, and 2021 columns into rows, creating a column called "Attribute" that contains the years and a column called "Value" that contains the sales data. This step makes the data more suitable for visualization and filtering by year. Action 3: Rename the Attribute column as Year and the value column as sales. Renaming the columns provides a more descriptive and meaningful structure for your data. After performing these actions, your data will be in a format that allows you to create visuals and add slicers for the month and year in Power BI.

semauni
Apr 21, 2023

Answer is correct! Transpose would cause the rows and columns to swap, so the months would become columns and the years would become rows. And, as another person here already stated, for an Unpivot you select the columns that you would like to remain the same, not the rows you want transformed.

panic_attack
Feb 23, 2024

This was also on the exam on 22/2/2024 (:

AKUMAR2104
Jul 21, 2023

This was on exam Today

nick0651
Oct 30, 2023

given exam on 21th Oct 2023 , This Question is in the exam . I scored 79 , No need to take ful version most of the question covern under 24 pages only.

AdrianBalescu
Dec 16, 2023

actually it helps a lot by taking the full version, it is the only website with forum community for all the questions, helps to analyze the right answer.

venupurna
Nov 6, 2023

This was in the exam today.

spamhz
Sep 11, 2023

i was tricked by "unpivot OTHER COLUMNS" do take note!

Shalaleh
May 1, 2023

answer is correct!

mtvl123
Jan 9, 2023

It's correct!

DUVANES
Mar 23, 2023

1. Seleccione las columnas Mes y MonthNumber. 2. Seleccione Despivotar otras columnas. 3. Cambie el nombre de la columna de atributos as Año y la columna Valor a Ventas.

JoaoTrade
Jan 9, 2023

Correct. A, B and C

jsking
Jan 9, 2023

Provided answer is correct.

apher
Jan 22, 2023

That's correct

Heshybay
Feb 8, 2023

The first action is to select the columns for 2019, 2020, and 2021.

pisanoagus
Feb 8, 2023

Not really. You first select the first two columns, then unpivot other columns (which are the year columns) Then you rename the output

ET_phone_home_son
Jul 4, 2023

Select Month & MonthNo > Unpivot other columns > Rename attribute (Year) and values (Sales)

Kiran37
Jul 21, 2024

Correct answer