Free PL-300 Exam Braindumps
Microsoft Power BI Data Analyst Questions 166–170 (page: 35)

Updated On: 10-Feb-2026

You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

  1. waterfall chart
  2. stacked area chart
  3. line chart
  4. donut chart

Answer(s): C



HOTSPOT (Drag and Drop is not supported)
You have a report in Power BI Desktop.
You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: moving fields from Explain by to Expand by
You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers.
Why do certain factors become influencers or stop being influencers as I move more fields into the Explain by field?
The visualization evaluates all explanatory factors together. A factor might be an influencer by itself, but when it's considered with other factors it might not.
Box 2: 3
0.30 instead of 0.10. A factor of 3 greater.


Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers



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?

  1. Key influencers
  2. Line and clustered column chart
  3. Q&A
  4. Funnel chart

Answer(s): A



HOTSPOT (Drag and Drop is not supported)
You have a table that contains the following three columns:
City
-Total Sales
-Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)
How should you configure the visualization? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: Total Sales
The key influencers visual helps you understand the factors that drive a metric you're interested in, here Total Sales. It analyzes your data, ranks the factors that matter, and displays them as key influencers.
Box 2: Occupation
Measures and summarized columns are automatically analyzed at the level of the Explain by fields used.


Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers



You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.
You add the following fields to the Explain By field:
-Customer Country
-Product Category
-Supplier Country
-Sales Employee
-Supplier Name
-Product Name
-Customer City
The key influencers visual returns the results shown in the following exhibit.
What can you identify from the visual?

  1. Customers in Austria order 18.8 more units than the average order quantity.
  2. Customers in Boise order 20.37 percent more than the average order quantity.
  3. Product Category positively influences the quantity per order.
  4. Customers in Cork order lower quantities than average.

Answer(s): A



Viewing page 35 of 68
Viewing questions 171 - 175 out of 398 questions


Post your Comments and Discuss Microsoft PL-300 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!