Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium
Question 10
Given below is an organization’s sales report for the last financial year.

Which of the following actions would you take to point out sales trends and highlight key takeaways from the entire report? You should be able to slice and dice the resulting information from any existing report visual.
-
A
Use the Power BI Q&A feature
-
B
Add a trendline
-
C
Right-click on a visual and click Summarize
-
D
Use smart narrative visual
Reveal correct answer
Correct answer: D
Explanation
When you right-click on a visual and click Summarize, Power BI creates a new smart narrative visual that provides a quick summary of the visual. But the trends and the key takeaways are limited only to the visual, not the entire report.

Reference Link: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-smart-narrative#smart-narrative-for-a-visual
Option B is incorrect.
To point out sales trends and highlight key takeaways for the entire report, use the smart narrative visual.

Reference Link: https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-smart-narrative#smart-narrative-for-a-page
You can slice the smart narrative visual by any other report visual. The smart narrative visual updates to display the information specific to the chosen field. For example, below we slice the visual by the Technology category (from the pie chart).

Option C is the correct answer.
We add a trendline to a specific visual, for example, a clustered column chart to capture the trend. Trendlines do not highlight trends for an entire report.

The output expected from the question is some kind of text information. Option A is incorrect.
Reference Link: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Power BI Q&A is a natural way to interact with your data and create report visuals. Smart narratives are more suited to the given objective. Option D is also incorrect.
Reference Link: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-tutorial-q-and-a?tabs=powerbi-desktop
PBIX File Link: Sales trends and highlight key takeaways
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
