PL-300 practice questions 251–260

1. Question 251 · 358 in bank

   DRAG DROP - You have a Power BI report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to 5. You need to format the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.

   

   Which three actions should you perform in sequence in Power BI Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Answer is correct Open the Background color dialog for the revenue column. set format style to rules. Add and configure a new rule for each value range.

   Source: Adapted from community discussion — JBTC

   

   Next question

2. Question 252 · 358 in bank

   You have a Power BI report that contains four pages. All the pages contain a slicer for a field named Country. You need to ensure that when a user selects a country on page 1, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages. What should you do?

   • ARemove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
   • BRemove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
   • CMove the Country slicer from page 2 and page 3 to page 1.
   • DSync the Country slicer on page 1, page 2, and page 3.

   Show answer

   Answer: D

   Next question

3. Question 253 · 358 in bank

   DRAG DROP - You use Power BI Desktop to create a Power BI data model and a blank report. You need to add the Word Cloud visual shown in the following exhibit to the report.

   

   The solution must minimize development effort. 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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Should be: 1. From Power BI Desktop, get the Word Cloud visual from Microsoft AppSource 2. Populate the Category, Value, and Excludes fields 3. Format the data colors and title (Colors in the Exhibit are different from the default colors) Tutorial: https://www.youtube.com/watch?v=brkbbS4GSGw

   Source: Adapted from community discussion — eholzapf

   

   Next question

4. Question 254 · 358 in bank

   You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

   • AKey influencers
   • BLine and clustered column chart
   • CQ&A
   • DFunnel chart

   Show answer

   Answer: A

   Next question

5. Question 255 · 358 in bank

   DRAG DROP - You have a Power BI report that contains five bookmarks. You need to add an object to the report from which users can navigate between three specific bookmarks. How should you complete the task? To answer, drag the appropriate actions to the correct steps. Each action 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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Shouldn't it be the other way around: Second step: Group the three bookmarks Third step: Change the Bookmark property for the button. Otherwise the group is not available to be chosen in the property.

   Source: Adapted from community discussion — Turmalino

   

   Next question

6. Question 256 · 358 in bank

   You plan to use Power BI to create sales invoices for customers. The solution must meet the following requirements: • Sales invoices must be exported in a PDF format. • The PDF exports must show all columns and rows clearly. What should you create?

   • Aa paginated report that contains a tablix
   • Ba dashboard that contains a table
   • Can interactive report that contains a table
   • Dan interactive report that contains a matrix

   Show answer

   Answer: A

   References

   • Microsoft Learn

   Next question

7. Question 257 · 358 in bank

   DRAG DROP - You have a Power BI report that contains three pages. The pages are used to analyze sales across various countries. You add a slicer named Country to each page of the report. You need to configure the report to meet the following requirements: • When a user selects a country on the first page, the report must filter the other pages. • The second and third pages must display only the filtered results. Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   The question is a little bit ambiguous: "The second and third pages must display only the filtered results" means, there cannot be slicer!!!

   Source: Adapted from community discussion — ZSun

   

   Next question

8. Question 258 · 358 in bank

   You have a Power BI report that contains a page. The page contains the following: • A shape named Shape1 • A card named Sales Summary • A clustered bar chart named Sales by Region You need to ensure that Sales Summary renders on top of Shape1. What should you modify?

   • ATab order in the Selection pane
   • BLayer order in the Selection pane
   • CMaintain layer order in the General visual settings
   • DVertical alignment in the Canvas settings

   Show answer

   Answer: B

   Explanation

   B. Layer order in the Selection pane To ensure that Sales Summary renders on top of Shape1, you need to adjust their layer order in the Selection pane. Power BI renders visuals based on the layer order in the Selection pane, with the topmost visual being rendered last and therefore appearing on top of other visuals. To adjust the layer order, you can select the visuals in the Selection pane and drag them up or down to change their position in the layer order. In this case, you would want to select Sales Summary and drag it above Shape1 in the layer order to ensure it is rendered on top. No confusion, and no need to discuss further

   Source: Adapted from community discussion — SanaCanada

   References

   • Microsoft Learn

   Next question

9. Question 259 · 358 in bank

   You have a Power BI report named Report1 and a dashboard named Dashboard1. Report1 contains a line chart named Sales by month. You pin the Sales by month visual to Dashboard1. In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard1. What should you do?

   • ARefresh the dataset used by Report1 and Dashboard1.
   • BPin the Sales by month bar chart to Dashboard1.
   • CSelect Refresh visuals for Dashboard1.
   • DEdit the details for the dashboard tile of Dashboard1.

   Show answer

   Answer: B

   Explanation

   B. Pin the Sales by month bar chart to Dashboard1. When you pin a visual to a dashboard, you are essentially taking a snapshot of that visual at that point in time and adding it to the dashboard as a tile. Any changes made to the original visual in the report will not automatically reflect in the dashboard tile. To display the bar chart on Dashboard1, you need to pin the new Sales by month bar chart to Dashboard1. No confusion, and no need to discuss further

   Source: Adapted from community discussion — SanaCanada

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

10. Question 260 · 358 in bank

    Select 3

    In Power BI Desktop, you are creating a report that will contain three pages. You need to create a custom tooltip page and prepare the page for use. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

    • AFor the tooltip page, set Allow use as tooltip to On.
    • BFor the target page, set Allow use as tooltip to On.
    • CConfigure filters on the target visual.
    • DFor the tooltip page, configure filters.
    • EAdd and configure visuals on the tooltip page.

    Show answer

    Answer: ADE

    Explanation

    1. E, Add and configure visuals on the tooltip page; 2. A, For the target page, set Allow use as tooltip to On; 3. D, Configure filter for preparation of tooltip page. So my answer is ADE

    Source: Adapted from community discussion — XiangIvyLi

    References

    • Microsoft Learn

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 251. 358 questions available.